Created 10-05-2016 05:45 AM
I have installed Apache Phoenix package on all HBASE master node and region servers. After I configured, I tried to run either sqlline.py or psql.py via edge node , but I faced this error, Please look into this and let me know.
[user@<edgenode host address> bin]$ sqlline.py Hostname:port:/hbase
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:<Hostname:port>:/hbase none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:<Hostname:port>:/hbase
java.lang.UnsupportedClassVersionError: JVMCFRE003 bad major version; class=org/apache/phoenix/jdbc/PhoenixDriver, offset=6
at java.lang.ClassLoader.defineClass(ClassLoader.java:286)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:74)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:538)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
at java.net.URLClassLoader.access$300(URLClassLoader.java:77)
at java.net.URLClassLoader$ClassFinder.run(URLClassLoader.java:1041)
at java.security.AccessController.doPrivileged(AccessController.java:448)
at java.net.URLClassLoader.findClass(URLClassLoader.java:427)
at java.lang.ClassLoader.loadClass(ClassLoader.java:676)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:358)
at java.lang.ClassLoader.loadClass(ClassLoader.java:642)
at java.lang.Class.forNameImpl(Native Method)
at java.lang.Class.forName(Class.java:240)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:115)
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:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
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:Hostname>
Created 10-05-2016 07:18 AM
can you check which version of java you are using? It should be OpenJDK and 1.7 or above?
Created 10-05-2016 05:49 AM
You are just passing :/hbase only.
[user@ bin]$ sqlline.py :/hbase
You need to pass <zookeeer_quorum>:<zk_client_port>:<hbase_parent_znode>
For ex:
[user@ bin]$ sqlline.py localhost:2181:/hbase
Created 10-05-2016 06:44 AM
By mistake i posted [user@ bin]$ sqlline.py :/hbase
I have given [user@ bin]$ sqlline.py localhost:2181:/hbase only.
Created 10-05-2016 07:18 AM
can you check which version of java you are using? It should be OpenJDK and 1.7 or above?
Created 10-05-2016 08:06 AM
Yeah its open jdk and java version 1.6.0
Created 10-05-2016 06:06 PM
1.6 is not supported. Please use JDK-1.8.