Have you restarted region server & master after you put phoenix core jar
into hbase class path and put the following config in the hbase-site.xml?
<property>
<name>hbase.regionserver.wal.codec</name>
<value>org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec</value>
</property>
On 4/28/14 10:27 PM, "Yuzhang Han" <[email protected]> wrote:
>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.checkClientServerComp
>atibility(ConnectionQueryServicesImpl.java:899)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(Co
>nnectionQueryServicesImpl.java:830)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(Connectio
>nQueryServicesImpl.java:1057)
> at
>org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClien
>t.java:1156)
> at
>org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:4
>22)
> at
>org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompil
>er.java:183)
> at
>org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.
>java:226)
> at
>org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.ja
>va:908)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryS
>ervicesImpl.java:1452)
> at
>org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDr
>iver.java:131)
> at
>org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDrive
>r.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(DelegatingMethodAccessorIm
>pl.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.jav
>a:180)
> at
>org.apache.phoenix.coprocessor.generated.MetaDataProtos$GetVersionRequest.
>getSerializedSize(MetaDataProtos.java:4480)
> at
>com.google.protobuf.AbstractMessageLite.toByteString(AbstractMessageLite.j
>ava:49)
> at
>org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(Re
>gionCoprocessorRpcChannel.java:77)
> at
>org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRp
>cChannel.java:51)
> at
>org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$St
>ub.getVersion(MetaDataProtos.java:5617)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQuer
>yServicesImpl.java:908)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQuer
>yServicesImpl.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(SQLEx
>ceptionCode.java:309)
> at
>org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionI
>nfo.java:133)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerComp
>atibility(ConnectionQueryServicesImpl.java:931)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(Co
>nnectionQueryServicesImpl.java:830)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(Connectio
>nQueryServicesImpl.java:1057)
> at
>org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClien
>t.java:1156)
> at
>org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:4
>22)
> at
>org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompil
>er.java:183)
> at
>org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.
>java:226)
> at
>org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.ja
>va:908)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryS
>ervicesImpl.java:1452)
> at
>org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDr
>iver.java:131)
> at
>org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDrive
>r.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(DelegatingMethodAccessorIm
>pl.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.jav
>a:180)
> at
>org.apache.phoenix.coprocessor.generated.MetaDataProtos$GetVersionRequest.
>getSerializedSize(MetaDataProtos.java:4480)
> at
>com.google.protobuf.AbstractMessageLite.toByteString(AbstractMessageLite.j
>ava:49)
> at
>org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(Re
>gionCoprocessorRpcChannel.java:77)
> at
>org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRp
>cChannel.java:51)
> at
>org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$St
>ub.getVersion(MetaDataProtos.java:5617)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQuer
>yServicesImpl.java:908)
> at
>org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQuer
>yServicesImpl.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
>
>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
