You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Vasanth Bhat <va...@gmail.com> on 2016/07/03 05:36:07 UTC
Re: Errors while launching sqlline
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 <va...@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.
>
>
> hadoop@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)
> hadoop@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
>
>
> hadoop@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
>
>
>
> hadoop@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
>
>
>
>
>
>
>
>
>
>
>
Re: Errors while launching sqlline
Posted by Josh Elser <jo...@gmail.com>.
You can check the dev list for the VOTE thread which contains a link to
the release candidate but it is not an official Apache Phoenix release yet.
Vasanth Bhat wrote:
> Thanks a lot Ankit.
>
> where do I download this from? I am looking at
> http://mirror.fibergrid.in/apache/phoenix/ don't seem to find the 4.8
> version here.
> Do I need to look at somewhere else?
>
> Thanks
> Vasanth
>
>
>
>
> On Thu, Jul 14, 2016 at 10:33 AM, Ankit Singhal<an...@gmail.com>
> wrote:
>
>> Hi Vasanth,
>>
>> RC for 4.8(with support of hbase-1.2) is just out today, you can try with
>> the latest build.
>>
>> Regards,
>> Ankit Singhal
>>
>> On Thu, Jul 14, 2016 at 10:06 AM, Vasanth Bhat<va...@gmail.com> wrote:
>>
>>> Thanks James.
>>>
>>> When are the early builds going to be available for Phoenix
>>> 4.8.0?
>>> also are the two errors below related to hbase version compatibility?
>>> There are also seems to be some java class loader related issue?
>>>
>>> How do I enable debug to get more information?
>>>
>>> Thanks
>>> Vasanth
>>>
>>>
>>> On Sun, Jul 3, 2016 at 12:05 PM, James Taylor<ja...@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<va...@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<va...@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.
>>>>>>
>>>>>>
>>>>>> hadoop@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)
>>>>>> hadoop@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
>>>>>>
>>>>>>
>>>>>> hadoop@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
>>>>>>
>>>>>>
>>>>>>
>>>>>> hadoop@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
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>
>
Re: Errors while launching sqlline
Posted by Josh Elser <jo...@gmail.com>.
You can check the dev list for the VOTE thread which contains a link to
the release candidate but it is not an official Apache Phoenix release yet.
Vasanth Bhat wrote:
> Thanks a lot Ankit.
>
> where do I download this from? I am looking at
> http://mirror.fibergrid.in/apache/phoenix/ don't seem to find the 4.8
> version here.
> Do I need to look at somewhere else?
>
> Thanks
> Vasanth
>
>
>
>
> On Thu, Jul 14, 2016 at 10:33 AM, Ankit Singhal<an...@gmail.com>
> wrote:
>
>> Hi Vasanth,
>>
>> RC for 4.8(with support of hbase-1.2) is just out today, you can try with
>> the latest build.
>>
>> Regards,
>> Ankit Singhal
>>
>> On Thu, Jul 14, 2016 at 10:06 AM, Vasanth Bhat<va...@gmail.com> wrote:
>>
>>> Thanks James.
>>>
>>> When are the early builds going to be available for Phoenix
>>> 4.8.0?
>>> also are the two errors below related to hbase version compatibility?
>>> There are also seems to be some java class loader related issue?
>>>
>>> How do I enable debug to get more information?
>>>
>>> Thanks
>>> Vasanth
>>>
>>>
>>> On Sun, Jul 3, 2016 at 12:05 PM, James Taylor<ja...@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<va...@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<va...@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.
>>>>>>
>>>>>>
>>>>>> hadoop@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)
>>>>>> hadoop@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
>>>>>>
>>>>>>
>>>>>> hadoop@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
>>>>>>
>>>>>>
>>>>>>
>>>>>> hadoop@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
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>
>
Re: Errors while launching sqlline
Posted by Vasanth Bhat <va...@gmail.com>.
Thanks a lot Ankit.
where do I download this from? I am looking at
http://mirror.fibergrid.in/apache/phoenix/ don't seem to find the 4.8
version here.
Do I need to look at somewhere else?
Thanks
Vasanth
On Thu, Jul 14, 2016 at 10:33 AM, Ankit Singhal <an...@gmail.com>
wrote:
> Hi Vasanth,
>
> RC for 4.8(with support of hbase-1.2) is just out today, you can try with
> the latest build.
>
> Regards,
> Ankit Singhal
>
> On Thu, Jul 14, 2016 at 10:06 AM, Vasanth Bhat <va...@gmail.com> wrote:
>
>> Thanks James.
>>
>> When are the early builds going to be available for Phoenix
>> 4.8.0?
>> also are the two errors below related to hbase version compatibility?
>> There are also seems to be some java class loader related issue?
>>
>> How do I enable debug to get more information?
>>
>> Thanks
>> Vasanth
>>
>>
>> On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
>> >>>
>> >>>
>> >>> hadoop@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)
>> >>> hadoop@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
>> >>>
>> >>>
>> >>> hadoop@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
>> >>>
>> >>>
>> >>>
>> >>> hadoop@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
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>
>> >
>>
>
>
Re: Errors while launching sqlline
Posted by Vasanth Bhat <va...@gmail.com>.
Thanks a lot Ankit.
where do I download this from? I am looking at
http://mirror.fibergrid.in/apache/phoenix/ don't seem to find the 4.8
version here.
Do I need to look at somewhere else?
Thanks
Vasanth
On Thu, Jul 14, 2016 at 10:33 AM, Ankit Singhal <an...@gmail.com>
wrote:
> Hi Vasanth,
>
> RC for 4.8(with support of hbase-1.2) is just out today, you can try with
> the latest build.
>
> Regards,
> Ankit Singhal
>
> On Thu, Jul 14, 2016 at 10:06 AM, Vasanth Bhat <va...@gmail.com> wrote:
>
>> Thanks James.
>>
>> When are the early builds going to be available for Phoenix
>> 4.8.0?
>> also are the two errors below related to hbase version compatibility?
>> There are also seems to be some java class loader related issue?
>>
>> How do I enable debug to get more information?
>>
>> Thanks
>> Vasanth
>>
>>
>> On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
>> >>>
>> >>>
>> >>> hadoop@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)
>> >>> hadoop@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
>> >>>
>> >>>
>> >>> hadoop@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
>> >>>
>> >>>
>> >>>
>> >>> hadoop@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
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>>
>> >>
>> >
>>
>
>
Re: Errors while launching sqlline
Posted by Ankit Singhal <an...@gmail.com>.
Hi Vasanth,
RC for 4.8(with support of hbase-1.2) is just out today, you can try with
the latest build.
Regards,
Ankit Singhal
On Thu, Jul 14, 2016 at 10:06 AM, Vasanth Bhat <va...@gmail.com> wrote:
> Thanks James.
>
> When are the early builds going to be available for Phoenix
> 4.8.0?
> also are the two errors below related to hbase version compatibility?
> There are also seems to be some java class loader related issue?
>
> How do I enable debug to get more information?
>
> Thanks
> Vasanth
>
>
> On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
> >>>
> >>>
> >>> hadoop@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)
> >>> hadoop@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
> >>>
> >>>
> >>> hadoop@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
> >>>
> >>>
> >>>
> >>> hadoop@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
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >
>
Re: Errors while launching sqlline
Posted by Ankit Singhal <an...@gmail.com>.
Hi Vasanth,
RC for 4.8(with support of hbase-1.2) is just out today, you can try with
the latest build.
Regards,
Ankit Singhal
On Thu, Jul 14, 2016 at 10:06 AM, Vasanth Bhat <va...@gmail.com> wrote:
> Thanks James.
>
> When are the early builds going to be available for Phoenix
> 4.8.0?
> also are the two errors below related to hbase version compatibility?
> There are also seems to be some java class loader related issue?
>
> How do I enable debug to get more information?
>
> Thanks
> Vasanth
>
>
> On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
> >>>
> >>>
> >>> hadoop@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)
> >>> hadoop@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
> >>>
> >>>
> >>> hadoop@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
> >>>
> >>>
> >>>
> >>> hadoop@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
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >
>
Re: Errors while launching sqlline
Posted by Vasanth Bhat <va...@gmail.com>.
Thanks James.
When are the early builds going to be available for Phoenix
4.8.0?
also are the two errors below related to hbase version compatibility?
There are also seems to be some java class loader related issue?
How do I enable debug to get more information?
Thanks
Vasanth
On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
>>>
>>>
>>> hadoop@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)
>>> hadoop@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
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
Re: Errors while launching sqlline
Posted by Vasanth Bhat <va...@gmail.com>.
Thanks a lot James.
Thanks
Vasanth
On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
>>>
>>>
>>> hadoop@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)
>>> hadoop@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
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
Re: Errors while launching sqlline
Posted by Vasanth Bhat <va...@gmail.com>.
Thanks James.
When are the early builds going to be available for Phoenix
4.8.0?
also are the two errors below related to hbase version compatibility?
There are also seems to be some java class loader related issue?
How do I enable debug to get more information?
Thanks
Vasanth
On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
>>>
>>>
>>> hadoop@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)
>>> hadoop@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
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
Re: Errors while launching sqlline
Posted by Vasanth Bhat <va...@gmail.com>.
Thanks a lot James.
Thanks
Vasanth
On Sun, Jul 3, 2016 at 12:05 PM, James Taylor <ja...@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 <va...@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 <va...@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.
>>>
>>>
>>> hadoop@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)
>>> hadoop@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
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>> hadoop@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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
Re: Errors while launching sqlline
Posted by James Taylor <ja...@apache.org>.
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 <va...@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 <va...@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.
>>
>>
>> hadoop@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)
>> hadoop@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
>>
>>
>> hadoop@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
>>
>>
>>
>> hadoop@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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
Re: Errors while launching sqlline
Posted by James Taylor <ja...@apache.org>.
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 <va...@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 <va...@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.
>>
>>
>> hadoop@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)
>> hadoop@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
>>
>>
>> hadoop@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
>>
>>
>>
>> hadoop@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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>