Thanks a lot James. Thanks Vasanth
On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <jamestay...@apache.org> wrote: > Phoenix 4.7.0 does not support HBase 1.2.1, but Phoenix 4.8.0 will. We're > very close to getting an RC up for this, so stay tuned. > > Thanks, > James > > On Sun, Jul 3, 2016 at 7:36 AM, Vasanth Bhat <vasb...@gmail.com> wrote: > >> Hi , >> >> I am stuck not able to progress. Any suggestions to debug the >> issue? Please advice. >> >> Thanks >> Vasanth >> >> >> On Thu, Jun 30, 2016 at 10:32 AM, Vasanth Bhat <vasb...@gmail.com> wrote: >> >>> Hi, >>> We are trying to do a small POC with Hbase 1.2.1 , Hadoop >>> 2.6.4, zookeeper 3.4.8 and phoenix 4.7.0. >>> >>> We have setup a three node zookeeper quorum, and hbase 1.2.1 setup with >>> 3 region servers. >>> The Hbase and zk setup seems to be OK, as we are able to do basic CRUD >>> operations with hbase. >>> >>> Now we are trying to setup phoenix and connect. >>> >>> When I try to launch sqlline.py, I get the following exception. >>> >>> >>> had...@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin/bin$ >>> *./sqlline.py >>> zk1.hbasepoc.com <http://zk1.hbasepoc.com>,zk2.hbasepoc.com >>> <http://zk2.hbasepoc.com>,zk3.hbasepoc.com:2181/hbase >>> <http://zk3.hbasepoc.com:2181/hbase>* >>> phoenix_utils.hbase_conf_dir => /etc/hbase/conf >>> phoenix_utils.phoenix_client_jar => >>> /u01/hadoop/phoenix-4.7.0-HBase-1.1-bin/bin/../phoenix-4.7.0-HBase-1.1-client.jar >>> java_cmd => /usr/jdk/instances/jdk1.8.0/bin/java $PHOENIX_OPTS -cp >>> "/etc/hbase/conf:/u01/hadoop/phoenix-4.7.0-HBase-1.1-bin/bin/../phoenix-4.7.0-HBase-1.1-client.jar:::/etc/hadoop/conf:" >>> -Dlog4j.configuration=file:/u01/hadoop/phoenix-4.7.0-HBase-1.1-bin/bin/log4j.properties >>> sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u jdbc:phoenix: >>> zk1.hbasepoc.com,zk2.hbasepoc.com,zk3.hbasepoc.com:2181/hbase -n none >>> -p none --color=true --fastConnect=false --verbose=true --incremental=false >>> --isolation=TRANSACTION_READ_COMMITTED >>> Setting property: [incremental, false] >>> Setting property: [isolation, TRANSACTION_READ_COMMITTED] >>> issuing: !connect jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc.com, >>> zk3.hbasepoc.com:2181/hbase none none >>> org.apache.phoenix.jdbc.PhoenixDriver >>> Connecting to jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc.com, >>> zk3.hbasepoc.com:2181/hbase >>> *java.lang.NoClassDefFoundError: Could not initialize class >>> org.apache.hadoop.hbase.util.Bytes$LexicographicalComparerHolder$UnsafeComparer* >>> at org.apache.hadoop.hbase.util.Bytes.putInt(Bytes.java:899) >>> at >>> org.apache.hadoop.hbase.KeyValue.createByteArray(KeyValue.java:1082) >>> at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:652) >>> at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:580) >>> at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:483) >>> at org.apache.hadoop.hbase.KeyValue.<init>(KeyValue.java:370) >>> at org.apache.hadoop.hbase.KeyValue.<clinit>(KeyValue.java:267) >>> at >>> org.apache.phoenix.util.KeyValueUtil.newKeyValue(KeyValueUtil.java:48) >>> at >>> org.apache.phoenix.util.KeyValueUtil.newKeyValue(KeyValueUtil.java:82) >>> at >>> org.apache.phoenix.jdbc.PhoenixDatabaseMetaData.<clinit>(PhoenixDatabaseMetaData.java:1004) >>> at >>> org.apache.phoenix.exception.SQLExceptionCode.<clinit>(SQLExceptionCode.java:238) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:392) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:211) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2269) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248) >>> at >>> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248) >>> at >>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233) >>> at >>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135) >>> 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(NativeMethodAccessorImpl.java:62) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> 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) >>> sqlline version 1.1.8 >>> 0: jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc> >>> >>> >>> Now when I try to quit the program, I again get new set of exceptions >>> as below. >>> >>> >>> >>> 0: jdbc:phoenix:zk1.hbasepoc.com,zk2.hbasepoc> !quit >>> *java.lang.NoClassDefFoundError: Could not initialize class >>> org.apache.phoenix.exception.SQLExceptionCode* >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:392) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:211) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2269) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248) >>> at >>> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248) >>> at >>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233) >>> at >>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135) >>> 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.close(Commands.java:906) >>> at sqlline.Commands.quit(Commands.java:870) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.lang.reflect.Method.invoke(Method.java:498) >>> at >>> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) >>> at sqlline.SqlLine.dispatch(SqlLine.java:804) >>> at sqlline.SqlLine.begin(SqlLine.java:681) >>> at sqlline.SqlLine.start(SqlLine.java:398) >>> at sqlline.SqlLine.main(SqlLine.java:292) >>> *Exception in thread "main" java.lang.NoClassDefFoundError: Could not >>> initialize class org.apache.phoenix.exception.SQLExceptionCode* >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:392) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:211) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2269) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2248) >>> at >>> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78) >>> at >>> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2248) >>> at >>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:233) >>> at >>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:135) >>> 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.close(Commands.java:906) >>> at sqlline.Commands.closeall(Commands.java:880) >>> at sqlline.SqlLine.begin(SqlLine.java:709) >>> at sqlline.SqlLine.start(SqlLine.java:398) >>> at sqlline.SqlLine.main(SqlLine.java:292) >>> had...@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin/bin$ >>> >>> >>> I looked into the jar "phoenix-4.7.0-HBase-1.1-client.jar" and see >>> that both of these classes are present >>> >>> >>> had...@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin$ *jar -tvf >>> phoenix-4.7.0-HBase-1.1-client.jar | grep >>> org.apache.hadoop.hbase.util.Bytes$LexicographicalComparerHolder$UnsafeComparer* >>> 1651 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$1.class >>> 770 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$2.class >>> 1795 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$ByteArrayComparator.class >>> 364 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$Comparer.class >>> 2208 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$LexicographicalComparerHolder$PureJavaComparer.class >>> 4489 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$LexicographicalComparerHolder$UnsafeComparer.class >>> 1984 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$LexicographicalComparerHolder.class >>> 1509 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes$RowEndKeyComparator.class >>> 31594 Sat Jan 16 18:17:00 IST 2016 >>> org/apache/hadoop/hbase/util/Bytes.class >>> >>> >>> >>> had...@client-121.hbasepoc.com:~/phoenix-4.7.0-HBase-1.1-bin$ *jar -tvf >>> phoenix-4.7.0-HBase-1.1-client.jar | grep >>> org.apache.phoenix.exception.SQLExceptionCode* >>> 997 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$16.class >>> 1084 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$5.class >>> 1080 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$6.class >>> 1041 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$7.class >>> 987 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$9.class >>> 947 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$8.class >>> 1032 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$Factory$2.class >>> 947 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$15.class >>> 729 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$Factory.class >>> 997 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$2.class >>> 992 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$12.class >>> 994 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$10.class >>> 936 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$1.class >>> 1038 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$14.class >>> 1018 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$4.class >>> 1016 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$3.class >>> 1000 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$13.class >>> 1160 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$Factory$1.class >>> 997 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode$11.class >>> 30164 Thu Mar 03 12:48:14 IST 2016 >>> org/apache/phoenix/exception/SQLExceptionCode.class >>> >>> I tried with both JDK 7 as well as JDK 8, the results are the same. >>> >>> Thanks >>> Vasanth >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >