Re: Phoenix-4 not working with HBase-0.98 and Hadoop-2.2.0

Tue, 29 Apr 2014 20:04:28 -0700 

Thanks.
I copied the property into hbase-site.xml in HBASE_HOME/conf/. I also copied phoenix-core-4.0.0-incubating.jar into HBASE_HOME/lib/, restarted the master and server. Still the same error. Any idea? Is is related protobuf version? 

On 4/29/2014 6:46 PM, Jeffrey Zhong wrote:

Yes, Hbase configuration should also have the config. Also from below
"copied the core jar into hbaseconf/", I think it's better to put the core
jar into your hbase lib directory due to the difference to include JAR and
configuration file into Hbase class path.




On 4/29/14 2:41 PM, "Yuzhang Han" <[email protected]> wrote:


Thanks Jeffrey.
Yes, every time after I regenerated and copied the core jar into hbase
conhf/, 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</valu
e>
    </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:153
9)
      at

org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:149
7)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCo
mp
atibility(ConnectionQueryServicesImpl.java:899)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(
Co
nnectionQueryServicesImpl.java:830)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(Connect
io
nQueryServicesImpl.java:1057)
      at

org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataCli
en
t.java:1156)
      at

org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java
:4
22)
      at

org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableComp
il
er.java:183)
      at

org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatemen
t.
java:226)
      at

org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.
ja
va:908)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQuer
yS
ervicesImpl.java:1452)
      at

org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoenix
Dr
iver.java:131)
      at

org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDri
ve
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.jav
a:
57)
      at

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Im
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.j
av
a:180)
      at

org.apache.phoenix.coprocessor.generated.MetaDataProtos$GetVersionReques
t.
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(Coprocessor
Rp
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(ConnectionQu
er
yServicesImpl.java:908)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQu
er
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.jav
a:
1145)
      at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va
: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(SQL
Ex
ceptionCode.java:309)
      at

org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptio
nI
nfo.java:133)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCo
mp
atibility(ConnectionQueryServicesImpl.java:931)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(
Co
nnectionQueryServicesImpl.java:830)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(Connect
io
nQueryServicesImpl.java:1057)
      at

org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataCli
en
t.java:1156)
      at

org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java
:4
22)
      at

org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableComp
il
er.java:183)
      at

org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatemen
t.
java:226)
      at

org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.
ja
va:908)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQuer
yS
ervicesImpl.java:1452)
      at

org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoenix
Dr
iver.java:131)
      at

org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDri
ve
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.jav
a:
57)
      at

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Im
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.j
av
a:180)
      at

org.apache.phoenix.coprocessor.generated.MetaDataProtos$GetVersionReques
t.
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(Coprocessor
Rp
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(ConnectionQu
er
yServicesImpl.java:908)
      at

org.apache.phoenix.query.ConnectionQueryServicesImpl$3.call(ConnectionQu
er
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.jav
a:
1145)
      at

java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
va
: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































					Reply via email to