The base environment is the version used by the CM-installed Cdh5.4.7,phoenix is phoenix-4.5.2-hbase-1.0-bin.
Exception message:Java.sql.SQLException:ERROR 1102 (XCL02): Cannot get all table regions
: http://mirror.bit.edu.cn/apache/phoenix/phoenix-4.5.2-HBase-1.0/bin/phoenix-4.5.2-HBase-1.0-bin.tar.gz
Installation procedure reference: https://phoenix.apache.org/installation.html
Exception information appears:
ERROR 1102 (XCL02): Cannot get all table regions (state=xcl02,code=1102) Java.sql.SQLException:ERROR1102(XCL02): Cannot get all table regions at org.apache.phoenix.exception.sqlexceptioncode$factory$1.newException (sqlexceptioncode.java:388) at Org.apache.phoenix.exception.SQLExceptionInfo.buildException (Sqlexceptioninfo.java:145) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions ( Connectionqueryservicesimpl.java:451) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility ( Connectionqueryservicesimpl.java:951) at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated ( Connectionqueryservicesimpl.java:877) at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable (Connectionqueryservicesimpl.java:1223) at Org.apache.phoenix.query.DelegateConnectionQueryServices.createTable ( Delegateconnectionqueryservices.java:113) at Org.apache.phoenix.schema.MetaDataClient.createTableInternal (Metadataclient.java:1937) at org.apache.phoenix.schema.MetaDataClient.createTable (Metadataclient.java:751) at org.apache.phoenix.compile.createtablecompiler$2.execute (createtablecompiler.java:186) at org.apache.phoenix.jdbc.phoenixstatement$2.call (phoenixstatement.java:320) R:error1102 (XCL02): Cannot get all table regions (state=xcl02,code=1102) Java.sql.SQLException:ERROR1102(XCL02): Cannot get all table regions at org.apache.phoenix.exception.sqlexceptioncode$factory$1.newException (sqlexceptioncode.java:388) at Org.apache.phoenix.exception.SQLExceptionInfo.buildException (Sqlexceptioninfo.java:145) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions ( Connectionqueryservicesimpl.java:451) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility ( Connectionqueryservicesimpl.java:951) at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated ( Connectionqueryservicesimpl.java:877) at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable (Connectionqueryservicesimpl.java:1223) at Org.apache.phoenix.query.DelegateConnectionQueryServices.createTable ( Delegateconnectionqueryservices.java:113) at Org.apache.phoenix.schema.MetaDataClient.createTableInternal (Metadataclient.java:1937) at org.apache.phoenix.schema.MetaDataClient.createTable (Metadataclient.java:751) at org.apache.phoenix.compile.createtablecompiler$2.execute (createtablecompiler.java:186) at org.apache.phoenix.jdbc.phoenixstatement$2.call (phoenixstatement.java:320) at org.apache.phoenix.jdbc.phoenixstatement$2.call (phoenixstatement.java:312) at Org.apache.phoenix.call.CallRunner.run (Callrunner.java:53) at Org.apache.phoenix.jdbc.PhoenixStatement.executeMutation (Phoenixstatement.java:310) at org.apache.phoenix.query.connectionqueryservicesimpl$12.call (connectionqueryservicesimpl.java:1896) at Org.apache.phoenix.util.PhoenixContextExecutor.call (Phoenixcontextexecutor.java:77) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.init (Connectionqueryservicesimpl.java:1896) at Org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices (Phoenixdriver.java:180) at Org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect (Phoenixembeddeddriver.java:132) at Org.apache.phoenix.jdbc.PhoenixDriver.connect (Phoenixdriver.java:151) at Sqlline. Databaseconnection.connect (Databaseconnection.java:157) at Sqlline. Databaseconnection.getconnection (Databaseconnection.java:203) at Sqlline.Commands.connect (Commands.java:1064) at Sqlline.Commands.connect (Commands.java:996) at Sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) at Sun.reflect.NativeMethodAccessorImpl . Invoke (Nativemethodaccessorimpl.java:57) at Sun.reflect.DelegatingMethodAccessorImpl.invoke (Delegatingmethodaccessorimpl.java:43) at Java.lang.reflect.Method.invoke (Method.java:30S) at Sqlline. Reflectivecommandhandler.execute (Reflectivecommandhandler.java:36) at Sqlline. Sqlline.dispatch (Sqlline.java:804) at Sqlline. Sqlline.initargs (Sqlline.java:588) at Sqlline. Sqlline.begin (Sqlline.java:656) at Sqlline. Sqlline.start (Sqlline.java:398) at Sqlline. Sqlline.main (Sqlline.java:292) caused By:org.apache.hadoop.hbase.client.NoServerForRegionException:No server address listed in Hbase:meta forRegion SYSTEM. catalog,,1452072854761. 0856fe481c7eb7920a7605037e9d1c2d. containing row at Org.apache.hadoop.hbase.client.connectionmanager$hconnect Ionimplementation.locateregioninmeta (Connectionmanager.java:1243) at Org.apache.hadoop.hbase.client.connectionmanager$hconnectionimplementation.locateregion ( Connectionmanager.java:1109) at Org.apache.hadoop.hbase.client.connectionmanager$hconnectionimplementation.relocateregion ( Connectionmanager.java:1080) at Org.apache.hadoop.hbase.client.connectionmanager$hconnectionimplementation.relocateregion ( Connectionmanager.java:1064) at Org.apache.hadoop.hbase.client.connectionmanager$hconnectionimplementation.getregionlocation ( Connectionmanager.java:885) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions ( Connectionqueryservicesimpl.java:437) ... 33morer:unable to loadnative-hadoop Library forYour platform ... using builtin-Java classes where Applicableerror:error1102 (XCL02): Cannot get all table regions (state=xcl02,code=1102) Java.sql.SQLException:ERROR1102(XCL02): Cannot get all table regions at org.apache.phoenix.exception.sqlexceptioncode$factory$1.newException (sqlexceptioncode.java:388) at Org.apache.phoenix.exception.SQLExceptionInfo.buildException (Sqlexceptioninfo.java:145) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions ( Connectionqueryservicesimpl.java:451) at Org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility ( Connectionqueryservicesimpl.java:951) at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated ( Connectionqueryservicesimpl.java:877) at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable (Connectionqueryservicesimpl.java:1223)
CDH5. 4.7+phoenix implementing Query HBase Exception: Java.sql.SQLException:ERROR 1102 (XCL02): Cannot get all table regions