Both,pom and code changes. On Thu, Jun 18, 2015 at 12:07 PM, Kumar Palaniappan < [email protected]> wrote:
> Baahu, did you change just the pom or the above said source code too? > > On Fri, Jun 12, 2015 at 1:11 AM, Bahubali Jain <[email protected]> wrote: > >> Thanks Sun...now its working. >> For others, below are the changes I did in the pom.xml >> <hbase.version>1.0.0-cdh5.4.2</hbase.version> >> <hadoop-two.version>2.6.0-cdh5.4.2</hadoop-two.version> >> <hadoop.version>2.6.0-cdh5.4.2</hadoop.version> >> >> Thanks, >> Baahu >> >> On Thu, Jun 11, 2015 at 11:43 AM, Fulin Sun <[email protected]> >> wrote: >> >>> Hi, there >>> >>> If you are using CDH 5.4.x and try to integrate with Phoenix 4.4 , you >>> may want to recompile phoenix 4.4 as the below thread. >>> >>> >>> http://mail-archives.apache.org/mod_mbox/phoenix-user/201506.mbox/%[email protected]%3E >>> >>> >>> Best, >>> Sun. >>> >>> ------------------------------ >>> ------------------------------ >>> >>> CertusNet >>> >>> >>> *From:* Bahubali Jain <[email protected]> >>> *Date:* 2015-06-11 12:11 >>> *To:* user <[email protected]> >>> *Subject:* Re: Error using sqlline.py >>> I have CDH 5.4 and the problem seems to be due to some incompatibility >>> as per the below thread. >>> >>> >>> http://mail-archives.apache.org/mod_mbox/phoenix-user/201506.mbox/%3CCAAF1JdhQUXwDwOJm6e38jjiBo-Kkm1=igagdrzmw-fxyrwk...@mail.gmail.com%3E >>> >>> On Wed, Jun 10, 2015 at 10:33 PM, Bahubali Jain <[email protected]> >>> wrote: >>> >>>> I downloaded from the below link >>>> http://supergsego.com/apache/phoenix/phoenix-4.4.0-HBase-1.0/ >>>> >>>> I have a single node install of hadoop and had restarted the hbase >>>> daemons. >>>> On Jun 10, 2015 10:22 PM, "Nick Dimiduk" <[email protected]> wrote: >>>> >>>>> Just double-check: you're using the HBase-1.0 Phoenix build with HBase >>>>> 1.0? Did you replace the Phoenix jar with the new 4.4.0 bits on all HBase >>>>> hosts and restart HBase daemons? >>>>> >>>>> -n >>>>> >>>>> On Wed, Jun 10, 2015 at 6:51 AM, Bahubali Jain <[email protected]> >>>>> wrote: >>>>> >>>>>> Hi, >>>>>> I am running into below issue while trying to connect using >>>>>> sqlline.py, can you please shed some light on this. >>>>>> >>>>>> Hbase Version is 1.0 and Phoeniix version is 4.4 >>>>>> >>>>>> >>>>>> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". >>>>>> SLF4J: Defaulting to no-operation (NOP) logger implementation >>>>>> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for >>>>>> further details. >>>>>> 15/06/10 06:43:36 WARN util.NativeCodeLoader: Unable to load >>>>>> native-hadoop library for your platform... using builtin-java classes >>>>>> where >>>>>> applicable >>>>>> 15/06/10 06:43:36 WARN impl.MetricsConfig: Cannot locate >>>>>> configuration: tried >>>>>> hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties >>>>>> 15/06/10 06:43:38 WARN ipc.CoprocessorRpcChannel: Call failed on >>>>>> IOException >>>>>> org.apache.hadoop.hbase.DoNotRetryIOException: >>>>>> org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: >>>>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>>>> at >>>>>> org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1148) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:10515) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7054) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1741) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1723) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:31447) >>>>>> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2035) >>>>>> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107) >>>>>> at java.lang.Thread.run(Thread.java:744) >>>>>> Caused by: java.lang.NoSuchMethodError: >>>>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildDeletedTable(MetaDataEndpointImpl.java:925) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:1001) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1097) >>>>>> ... 10 more >>>>>> >>>>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >>>>>> Method) >>>>>> at >>>>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>>>>> at >>>>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>>>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>>>>> at >>>>>> org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:106) >>>>>> at >>>>>> org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:95) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(ProtobufUtil.java:313) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1609) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:92) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call(RegionCoprocessorRpcChannel.java:89) >>>>>> at >>>>>> org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel.callExecService(RegionCoprocessorRpcChannel.java:95) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod(CoprocessorRpcChannel.java:56) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService$Stub.createTable(MetaDataProtos.java:10695) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl$6.call(ConnectionQueryServicesImpl.java:1261) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl$6.call(ConnectionQueryServicesImpl.java:1250) >>>>>> at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1737) >>>>>> at java.util.concurrent.FutureTask.run(FutureTask.java:262) >>>>>> 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:744) >>>>>> Caused by: >>>>>> org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException): >>>>>> org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: >>>>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>>>> at >>>>>> org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1148) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:10515) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7054) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1741) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1723) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:31447) >>>>>> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2035) >>>>>> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107) >>>>>> at java.lang.Thread.run(Thread.java:744) >>>>>> Caused by: java.lang.NoSuchMethodError: >>>>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildDeletedTable(MetaDataEndpointImpl.java:925) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:1001) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1097) >>>>>> ... 10 more >>>>>> >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1199) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:216) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:300) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.execService(ClientProtos.java:31913) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.ProtobufUtil.execService(ProtobufUtil.java:1605) >>>>>> ... 13 more >>>>>> 15/06/10 06:43:38 WARN client.HTable: Error calling coprocessor >>>>>> service >>>>>> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService >>>>>> for >>>>>> row \x00SYSTEM\x00CATALOG >>>>>> java.util.concurrent.ExecutionException: >>>>>> org.apache.hadoop.hbase.DoNotRetryIOException: >>>>>> org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: >>>>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>>>> at >>>>>> org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1148) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:10515) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7054) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1741) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1723) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:31447) >>>>>> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2035) >>>>>> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107) >>>>>> at java.lang.Thread.run(Thread.java:744) >>>>>> Caused by: java.lang.NoSuchMethodError: >>>>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildDeletedTable(MetaDataEndpointImpl.java:925) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:1001) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1097) >>>>>> ... 10 more >>>>>> >>>>>> at java.util.concurrent.FutureTask.report(FutureTask.java:122) >>>>>> at java.util.concurrent.FutureTask.get(FutureTask.java:188) >>>>>> at >>>>>> org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1749) >>>>>> at >>>>>> org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1705) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1024) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1004) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1249) >>>>>> at >>>>>> org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:112) >>>>>> at >>>>>> org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1902) >>>>>> at >>>>>> org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:744) >>>>>> at >>>>>> org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:303) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:295) >>>>>> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:293) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1236) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1891) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1860) >>>>>> at >>>>>> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) >>>>>> at >>>>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1860) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:131) >>>>>> at >>>>>> org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133) >>>>>> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) >>>>>> 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:57) >>>>>> at >>>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>>>> at java.lang.reflect.Method.invoke(Method.java:606) >>>>>> 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) >>>>>> Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: >>>>>> org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: >>>>>> org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; >>>>>> at >>>>>> org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1148) >>>>>> at >>>>>> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:10515) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7054) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1741) >>>>>> at >>>>>> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1723) >>>>>> at >>>>>> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:31447) >>>>>> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2035) >>>>>> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130) >>>>>> at >>>>>> org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107) >>>>>> at java.lang.Thread.run(Thread.java:744) >>>>>> >>>>>> >>>>> >>> >>> >>> -- >>> Twitter:http://twitter.com/Baahu >>> >>> >> >> >> -- >> Twitter:http://twitter.com/Baahu >> >> > -- Twitter:http://twitter.com/Baahu
