atom feed6 messages in org.apache.phoenix.userRe: Phoenix-4 not working with HBase-...
FromSent OnAttachments
Yuzhang HanApr 28, 2014 10:27 pm 
Jeffrey ZhongApr 29, 2014 10:31 am 
Yuzhang HanApr 29, 2014 2:41 pm 
Jeffrey ZhongApr 29, 2014 3:41 pm 
Yuzhang HanApr 29, 2014 8:03 pm 
Jeffrey ZhongApr 30, 2014 10:32 am 
Subject:Re: Phoenix-4 not working with HBase-0.98 and Hadoop-2.2.0
From:Yuzhang Han (yuzh@gmail.com)
Date:Apr 29, 2014 2:41:42 pm
List:org.apache.phoenix.user

Thanks Jeffrey. Yes, every time after I regenerated and copied the core jar into hbase conf/, I restarted HBase master and server (actually I only have a single region server). And this property has always been in the hbase-site.xml in PHOENIX_HOME/bin/. Should I put this property also into the hbase-site.xml in my HBase?

On 4/29/2014 1:37 PM, Jeffrey Zhong wrote:

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" <yuzh@gmail.com> 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