Dbeaver Phoenix 各种报错

Dbeaver  连接Phoenix  失败，各种报错：

Unexpected driver error occurred while connecting to the database
java.lang.RuntimeException:class org.apache.hadoop.security.JniBasedUnixGroupsMappingWithFallback not org.apache.hadoop.security.GroupMappingServiceProvider

ERROR 103 (08004): Unable to establish connection.
java.lang.reflect.InvocationTargetException
'void sun.misc.Unsafe.putLong(java.lang.Object, int, long)'

Unexpected driver error occurred while connecting to the database
Inconsistent constant pool data in classfile for class org/apache/hadoop/hbase/client/Row. Method 'int lambda$static$28(org.apache.hadoop.hbase.client.Row, org.apache.hadoop.hbase.client.Row)' at index 57 is CONSTANT_MethodRef and should be CONSTANT_InterfaceMethodRef

ERROR 726 (43M10): Inconsistent namespace mapping properties. Ensure that config phoenix.schema.isNamespaceMappingEnabled is consistent on client and server.

换了各种版本的驱动、添加了驱动属性都不行

phoenix.schema.isNamespaceMappingEnabled true
phoenix.schema.mapSystemTablesToNamespace true

最终解决方法
1、将hbase 安装路径中jar里面对应的jar全部复制到一个目录中（比如libs）

antlr-runtime-3.5.2.jar
aopalliance-1.0.jar
aopalliance-repackaged-2.5.0-b32.jar
apacheds-i18n-2.0.0-M15.jar
apacheds-kerberos-codec-2.0.0-M15.jar
api-asn1-api-1.0.0-M20.jar
api-util-1.0.0-M20.jar
asm-3.1.jar
asm-all-5.0.2.jar
audience-annotations-0.5.0.jar
avro-1.7.4.jar
commons-beanutils-1.7.0.jar
commons-beanutils-core-1.8.0.jar
commons-cli-1.4.jar
commons-codec-1.10.jar
commons-collections-3.2.2.jar
commons-compress-1.4.1.jar
commons-configuration-1.6.jar
commons-crypto-1.0.0.jar
commons-csv-1.0.jar
commons-daemon-1.0.13.jar
commons-digester-1.8.jar
commons-httpclient-3.1.jar
commons-io-2.5.jar
commons-lang-2.6.jar
commons-lang3-3.6.jar
commons-logging-1.1.3.jar
commons-math3-3.1.1.jar
commons-net-3.1.jar
curator-client-2.7.1.jar
curator-framework-2.7.1.jar
curator-recipes-2.7.1.jar
disruptor-3.3.6.jar
fastutil-6.5.6.jar
findbugs-annotations-1.3.9-1.jar
gson-2.2.4.jar
guava-13.0.1.jar
guice-3.0.jar
guice-assistedinject-3.0.jar
guice-servlet-4.0.jar
hadoop-annotations-3.0.0.jar
hadoop-auth-2.7.7.jar
hadoop-client-2.7.4.jar
hadoop-common-2.7.7.jar
hadoop-distcp-2.7.4.jar
hadoop-hdfs-2.7.4.jar
hadoop-hdfs-client-3.0.0.jar
hadoop-mapreduce-client-app-2.7.4.jar
hadoop-mapreduce-client-common-2.7.4.jar
hadoop-mapreduce-client-core-3.0.0.jar
hadoop-mapreduce-client-jobclient-2.7.4.jar
hadoop-mapreduce-client-shuffle-2.7.4.jar
hadoop-yarn-api-2.7.4.jar
hadoop-yarn-client-3.0.0.jar
hadoop-yarn-common-3.0.0.jar
hadoop-yarn-server-common-2.7.4.jar
hbase-annotations-2.0.0.jar
hbase-client-2.0.3.jar
hbase-common-2.0.3.jar
hbase-hadoop-compat-2.0.3.jar
hbase-hadoop2-compat-2.0.3.jar
hbase-http-2.0.0.jar
hbase-mapreduce-2.0.0.jar
hbase-metrics-2.0.3.jar
hbase-metrics-api-2.0.3.jar
hbase-procedure-2.0.0.jar
hbase-protocol-2.0.3.jar
hbase-protocol-shaded-2.0.3.jar
hbase-replication-2.0.0.jar
hbase-server-2.0.0.jar
hbase-shaded-miscellaneous-2.1.0.jar
hbase-shaded-netty-2.1.0.jar
hbase-shaded-protobuf-2.1.0.jar
hbase-zookeeper-2.0.0.jar
hk2-api-2.5.0-b32.jar
hk2-locator-2.5.0-b32.jar
hk2-utils-2.5.0-b32.jar
htrace-core-3.1.0-incubating.jar
htrace-core4-4.2.0-incubating.jar
httpclient-4.0.1.jar
httpcore-4.0.1.jar
i18n-util-1.0.4.jar
icu4j-60.2.jar
icu4j-charset-60.2.jar
icu4j-localespi-60.2.jar
jackson-annotations-2.9.0.jar
jackson-core-2.9.2.jar
jackson-core-asl-1.9.2.jar
jackson-databind-2.9.2.jar
jackson-jaxrs-1.9.2.jar
jackson-jaxrs-base-2.7.8.jar
jackson-jaxrs-json-provider-2.7.8.jar
jackson-mapper-asl-1.9.2.jar
jackson-module-jaxb-annotations-2.7.8.jar
jackson-xc-1.9.2.jar
jamon-runtime-2.4.1.jar
javassist-3.20.0-GA.jar
javax.annotation-api-1.2.jar
javax.el-3.0.1-b12.jar
javax.inject-1.jar
javax.inject-2.5.0-b32.jar
javax.servlet-api-3.1.0.jar
javax.servlet.jsp-2.3.2.jar
javax.servlet.jsp-api-2.3.1.jar
javax.ws.rs-api-2.0.1.jar
jaxb-api-2.2.11.jar
jaxb-impl-2.2.3-1.jar
jcip-annotations-1.0-1.jar
jcodings-1.0.18.jar
jersey-client-1.19.jar
jersey-client-2.25.1.jar
jersey-common-2.25.1.jar
jersey-container-servlet-core-2.25.1.jar
jersey-core-1.9.jar
jersey-guava-2.25.1.jar
jersey-guice-1.19.jar
jersey-json-1.19.jar
jersey-media-jaxb-2.25.1.jar
jersey-server-1.9.jar
jersey-server-2.25.1.jar
jersey-servlet-1.19.jar
jettison-1.3.8.jar
jetty-6.1.26.jar
jetty-http-9.3.19.v20170502.jar
jetty-io-9.3.19.v20170502.jar
jetty-security-9.3.19.v20170502.jar
jetty-server-9.3.19.v20170502.jar
jetty-servlet-9.3.19.v20170502.jar
jetty-sslengine-6.1.26.jar
jetty-util-6.1.26.jar
jetty-util-9.3.19.v20170502.jar
jetty-util-ajax-9.3.19.v20170502.jar
jetty-webapp-9.3.19.v20170502.jar
jetty-xml-9.3.19.v20170502.jar
jline-2.11.jar
joda-time-1.6.jar
joni-2.1.11.jar
jsch-0.1.54.jar
jsr305-2.0.1.jar
leveldbjni-all-1.8.jar
libthrift-0.9.0.jar
log4j-1.2.17.jar
metrics-core-3.2.1.jar
netty-3.10.5.Final.jar
netty-all-4.0.23.Final.jar
okhttp-2.4.0.jar
okio-1.4.0.jar
osgi-resource-locator-1.0.1.jar
paranamer-2.3.jar
phoenix-core-5.0.0-HBase-2.0.jar
protobuf-java-2.5.0.jar
slf4j-api-1.7.25.jar
slf4j-log4j12-1.6.1.jar
snappy-0.3.jar
snappy-java-1.0.4.1.jar
sqlline-1.2.0.jar
stream-2.9.5.jar
tephra-api-0.14.0-incubating.jar
tephra-core-0.14.0-incubating.jar
tephra-hbase-compat-2.0-0.14.0-incubating.jar
twill-api-0.8.0.jar
twill-common-0.8.0.jar
twill-core-0.8.0.jar
twill-discovery-api-0.8.0.jar
twill-discovery-core-0.8.0.jar
twill-zookeeper-0.8.0.jar
validation-api-1.1.0.Final.jar
xmlenc-0.52.jar
xz-1.0.jar
zookeeper-3.4.10.jar

2、从Hbase集群中拷贝hbase-site.xml，将其添加到libs目录中的phoenix-core-5.0.0-HBase-2.0.jar里

3、打开Dbeaver，新建Phoenix连接，填写主机(hdp01,hdp02,hdp03)、端口(2181)、用户名、密码，点击“编辑驱动设置”

4、切换到“库”Tab，删除原来的驱动文件，点击“添加文件夹”，选择libs目录，然后点击“找到类”，选择org.apache.phoenix.jdbc.PhoenixDriver

5、确定后，双击配置好的Phoenix连接，如果还报错，重启Dbeaver后再次连接。