Mark, Thank you for reply. But command takes 20 mins to get response ? On Fri, Jan 13, 2017 at 7:40 PM, Mark Heppner <heppner.m...@gmail.com> wrote:
> I think you need to start it with either of these: > ./bin/sqlline.py localhost:2181:/hbase > ./bin/sqlline.py localhost:2181:/hbase-unsecure > > On Fri, Jan 13, 2017 at 8:49 AM, Chetan Khatri < > chetan.opensou...@gmail.com> wrote: > >> Hello Community, >> >> I have installed and configured Apache Phoenix on Single Node Ubuntu >> 16.04 machine: >> - Hadoop 2.7 >> - HBase 1.2.4 >> - Phoenix -4.8.2-HBase-1.2 >> >> Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed >> with bin/hbase classpath | grep 'phoenix' and I am using embedded >> zookeeper, so my hbase-site.xml looks like below: >> >> <configuration> >> <property> >> <name>hbase.rootdir</name> >> <value>file:///home/hduser/hbase</value> >> </property> >> </configuration> >> >> I am able to read / write to HBase from shell and Apache Spark. >> >> *Errors while accessing with **sqlline**:* >> >> 1) bin/sqlline.py localhost:2181 >> >> Error: >> >> 1. Command made process hang. >> 2. >> Error: ERROR 1102 (XCL02): Cannot get all table regions. >> (state=XCL02,code=1102) >> java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table regions. >> at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newE >> xception(SQLExceptionCode.java:455) >> at org.apache.phoenix.exception.SQLExceptionInfo.buildException >> (SQLExceptionInfo.java:145) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllT >> ableRegions(ConnectionQueryServicesImpl.java:546) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl.checkCl >> ientServerCompatibility(ConnectionQueryServicesImpl.java:1162) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureT >> ableCreated(ConnectionQueryServicesImpl.java:1068) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl.createT >> able(ConnectionQueryServicesImpl.java:1388) >> at org.apache.phoenix.schema.MetaDataClient.createTableInternal >> (MetaDataClient.java:2298) >> at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDat >> aClient.java:940) >> at org.apache.phoenix.compile.CreateTableCompiler$2.execute(Cre >> ateTableCompiler.java:193) >> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState >> ment.java:344) >> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState >> ment.java:332) >> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho >> enixStatement.java:331) >> at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(Phoen >> ixStatement.java:1423) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl$13. >> call(ConnectionQueryServicesImpl.java:2352) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl$13. >> call(ConnectionQueryServicesImpl.java:2291) >> at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixC >> ontextExecutor.java:76) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(Co >> nnectionQueryServicesImpl.java:2291) >> at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServ >> ices(PhoenixDriver.java:232) >> at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnecti >> on(PhoenixEmbeddedDriver.java:147) >> at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202) >> 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(NativeMethodAcce >> ssorImpl.java:62) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >> thodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:498) >> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa >> ndler.java:36) >> at sqlline.SqlLine.dispatch(SqlLine.java:803) >> 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 for region >> SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8. >> containing row >> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection >> Implementation.locateRegionInMeta(ConnectionManager.java:1318) >> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection >> Implementation.locateRegion(ConnectionManager.java:1181) >> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection >> Implementation.relocateRegion(ConnectionManager.java:1152) >> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection >> Implementation.relocateRegion(ConnectionManager.java:1136) >> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection >> Implementation.getRegionLocation(ConnectionManager.java:957) >> at org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllT >> ableRegions(ConnectionQueryServicesImpl.java:531) >> ... 32 more >> sqlline version 1.1.9 >> >> Kindly let me know how to fix this error. >> >> Thanks, >> >> >> > > > -- > Mark Heppner >