Hi,
I have problems with running Phoenix-4.0.0 on HBase-0.98.1 and
Hadoop-2.2.0. Phoenix and HBase are built from source. HBase runs well
on Hadoop. But when I try to run any query on SqlLine, for example,
creating a table, I get the following. I copied phoenix-core.jar to
HBASE_HOME/lib. I have tried building Phoenix with and without
-Dhadoop.profile=2, ending up in the same errors. What could be the cause?
Thanks very much!
/phoenix-4.0.0-incubating-src# bin/sqlline.py localhost
$SQL_HBASE_EXPERIMENTS_HOME/customer_14_createTable.sql
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
Setting property: [run,
/root/sqlHBaseExperiments/customer_14_createTable.sql]
issuing: !connect jdbc:phoenix:localhost none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost
14/04/29 01:32:33 WARN util.NativeCodeLoader: Unable to load
native-hadoop library for your platform... using builtin-java classes
where applicable
14/04/29 01:32:34 WARN client.HTable: Error calling coprocessor service
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService
for row
java.util.concurrent.ExecutionException:
java.lang.UnsupportedOperationException: This is supposed to be
overridden by subclasses.
at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
at java.util.concurrent.FutureTask.get(FutureTask.java:111)
at
org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1539)
at
org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1497)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:899)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:830)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1057)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1156)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422)
at
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:908)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1452)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:131)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
at sqlline.SqlLine.dispatch(SqlLine.java:817)
at sqlline.SqlLine.initArgs(SqlLine.java:633)
at sqlline.SqlLine.begin(SqlLine.java:680)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
Caused by: java.lang.UnsupportedOperationException: This is supposed to
be overridden by subclasses.
at
com.google.protobuf.GeneratedMessage.getUnknownFields(GeneratedMessage.java:180)
at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$GetVersionRequest.getSerializedSize(MetaDataProtos.java:4480)
at
com.google.protobuf.AbstractMessageLite.toByteString(AbstractMessageLite.java:49)
at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:77)
at
org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:51)
at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$Stub.getVersion(MetaDataProtos.java:5617)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQueryServicesImpl.java:908)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQueryServicesImpl.java:900)
at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1527)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
Error: ERROR 2006 (INT08): Incompatible jars detected between client and
server. Ensure that phoenix.jar is put on the classpath of HBase in
every region server: This is supposed to be overridden by subclasses.
(state=INT08,code=2006)
java.sql.SQLException: ERROR 2006 (INT08): Incompatible jars detected
between client and server. Ensure that phoenix.jar is put on the
classpath of HBase in every region server: This is supposed to be
overridden by subclasses.
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:309)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:931)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:830)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1057)
at
org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1156)
at
org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422)
at
org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:908)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1452)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:131)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
at sqlline.SqlLine.dispatch(SqlLine.java:817)
at sqlline.SqlLine.initArgs(SqlLine.java:633)
at sqlline.SqlLine.begin(SqlLine.java:680)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
Caused by: java.lang.UnsupportedOperationException: This is supposed to
be overridden by subclasses.
at
com.google.protobuf.GeneratedMessage.getUnknownFields(GeneratedMessage.java:180)
at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$GetVersionRequest.getSerializedSize(MetaDataProtos.java:4480)
at
com.google.protobuf.AbstractMessageLite.toByteString(AbstractMessageLite.java:49)
at
org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:77)
at
org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:51)
at
org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$Stub.getVersion(MetaDataProtos.java:5617)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQueryServicesImpl.java:908)
at
org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQueryServicesImpl.java:900)
at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1527)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
1/1 CREATE TABLE IF NOT EXISTS CUSTOMER_14 (C_CUSTKEY INTEGER
NOT NULL PRIMARY KEY, CF.C_NAME VARCHAR, CF.C_ADDRESS VARCHAR,
CF.C_NATIONKEY INTEGER, CF.C_PHONE VARCHAR, CF.C_ACCTBAL FLOAT,
CF.C_MKTSEGMENT VARCHAR, CF.C_COMMENT VARCHAR) split on (100000, 200000,
300000, 400000, 500000, 600000, 700000, 800000, 900000, 1000000,
1100000, 1200000, 1300000, 1400000, 1500000, 1600000, 1700000, 1800000,
1900000, 2000000, 2100000, 2200000, 2300000, 2400000, 2500000, 2600000,
2700000, 2800000, 2900000, 3000000, 3100000, 3200000, 3300000, 3400000,
3500000);
No current connection
Aborting command set because "force" is false and command failed:
"CREATE TABLE IF NOT EXISTS CUSTOMER_14 (C_CUSTKEY INTEGER NOT NULL
PRIMARY KEY, CF.C_NAME VARCHAR, CF.C_ADDRESS VARCHAR, CF.C_NATIONKEY
INTEGER, CF.C_PHONE VARCHAR, CF.C_ACCTBAL FLOAT, CF.C_MKTSEGMENT
VARCHAR, CF.C_COMMENT VARCHAR) split on (100000, 200000, 300000, 400000,
500000, 600000, 700000, 800000, 900000, 1000000, 1100000, 1200000,
1300000, 1400000, 1500000, 1600000, 1700000, 1800000, 1900000, 2000000,
2100000, 2200000, 2300000, 2400000, 2500000, 2600000, 2700000, 2800000,
2900000, 3000000, 3100000, 3200000, 3300000, 3400000, 3500000);"
Connection is already closed.
sqlline version 1.1.2
