Haven't tested CDH 5.2, but we know CDH 5.7 works well with Kylin. On Fri, Aug 19, 2016 at 1:34 PM, lxw <[email protected]> wrote:
> Hi,experts: > > After create and build successfully, I use SQL to query the cube and > got error: > > Error while executing SQL "select advid_, sum(pv_) as pv from > lxw1234.t_table group by advid_ limit 10": Error in coprocessor > > I use kylin-1.5.3、hbase-0.98.6-cdh5.2.0, and some other cubes can be > normal query . > > The error log is : > > 2016-08-19 13:24:55,862 WARN [kylin-coproc--pool5-t19] > ipc.CoprocessorRpcChannel:59 : Call failed on IOException > org.apache.hadoop.hbase.DoNotRetryIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: > java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2067) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) > at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:114) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor. > java:94) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:328) > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:283) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:322) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:295) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:189) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod( > CubeVisitProtos.java:4353) > at org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:5602) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execServiceOnRegion(HRegionServer.java:3416) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execService(HRegionServer.java:3398) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29591) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > ... 4 more > > at sun.reflect.GeneratedConstructorAccessor86.newInstance(Unknown > Source) > 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:304) > at org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1627) > at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call( > RegionCoprocessorRpcChannel.java:93) > at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call( > RegionCoprocessorRpcChannel.java:90) > at org.apache.hadoop.hbase.client.RpcRetryingCaller. > callWithRetries(RpcRetryingCaller.java:114) > at org.apache.hadoop.hbase.client.RpcRetryingCaller. > callWithRetries(RpcRetryingCaller.java:90) > at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel. > callExecService(RegionCoprocessorRpcChannel.java:96) > at org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod( > CoprocessorRpcChannel.java:57) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.generated.CubeVisitProtos$CubeVisitService$Stub. > visitCube(CubeVisitProtos.java:4400) > at org.apache.kylin.storage.hbase.cube.v2. > CubeHBaseEndpointRPC$1$1.call(CubeHBaseEndpointRPC.java:371) > at org.apache.kylin.storage.hbase.cube.v2. > CubeHBaseEndpointRPC$1$1.call(CubeHBaseEndpointRPC.java:367) > at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1542) > 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: > java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2067) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) > at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:114) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor. > java:94) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:328) > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:283) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:322) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:295) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:189) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod( > CubeVisitProtos.java:4353) > at org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:5602) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execServiceOnRegion(HRegionServer.java:3416) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execService(HRegionServer.java:3398) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29591) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > ... 4 more > > at org.apache.hadoop.hbase.ipc.RpcClient.call(RpcClient.java:1457) > at org.apache.hadoop.hbase.ipc.RpcClient.callBlockingMethod( > RpcClient.java:1661) > at org.apache.hadoop.hbase.ipc.RpcClient$ > BlockingRpcChannelImplementation.callBlockingMethod(RpcClient.java:1719) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$BlockingStub.execService( > ClientProtos.java:30014) > at org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1623) > ... 14 more > 2016-08-19 13:24:55,864 WARN [pool-8-thread-9] client.HTable:1556 : Error > calling coprocessor service org.apache.kylin.storage. > hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService > for row \x00\x00 > java.util.concurrent.ExecutionException: > org.apache.hadoop.hbase.DoNotRetryIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.NoClassDefFoundError: > Could not initialize class org.apache.kylin.metadata.datatype.DataType > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2067) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) > at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:114) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor. > java:94) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:328) > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:283) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:322) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:295) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:189) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod( > CubeVisitProtos.java:4353) > at org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:5602) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execServiceOnRegion(HRegionServer.java:3416) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execService(HRegionServer.java:3398) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29591) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > ... 4 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:1554) > at org.apache.kylin.storage.hbase.cube.v2. > CubeHBaseEndpointRPC$1.run(CubeHBaseEndpointRPC.java:366) > at java.util.concurrent.Executors$RunnableAdapter. > call(Executors.java:471) > 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.DoNotRetryIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: java.lang.NoClassDefFoundError: > Could not initialize class org.apache.kylin.metadata.datatype.DataType > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2067) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) > at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:114) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor. > java:94) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:328) > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:283) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:322) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:295) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:189) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod( > CubeVisitProtos.java:4353) > at org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:5602) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execServiceOnRegion(HRegionServer.java:3416) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execService(HRegionServer.java:3398) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29591) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > ... 4 more > > at sun.reflect.GeneratedConstructorAccessor86.newInstance(Unknown > Source) > 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:304) > at org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1627) > at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call( > RegionCoprocessorRpcChannel.java:93) > at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel$1.call( > RegionCoprocessorRpcChannel.java:90) > at org.apache.hadoop.hbase.client.RpcRetryingCaller. > callWithRetries(RpcRetryingCaller.java:114) > at org.apache.hadoop.hbase.client.RpcRetryingCaller. > callWithRetries(RpcRetryingCaller.java:90) > at org.apache.hadoop.hbase.ipc.RegionCoprocessorRpcChannel. > callExecService(RegionCoprocessorRpcChannel.java:96) > at org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel.callMethod( > CoprocessorRpcChannel.java:57) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.generated.CubeVisitProtos$CubeVisitService$Stub. > visitCube(CubeVisitProtos.java:4400) > at org.apache.kylin.storage.hbase.cube.v2. > CubeHBaseEndpointRPC$1$1.call(CubeHBaseEndpointRPC.java:371) > at org.apache.kylin.storage.hbase.cube.v2. > CubeHBaseEndpointRPC$1$1.call(CubeHBaseEndpointRPC.java:367) > at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1542) > ... 4 more > Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org. > apache.hadoop.hbase.DoNotRetryIOException): > org.apache.hadoop.hbase.DoNotRetryIOException: > java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2067) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:108) > at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop( > RpcExecutor.java:114) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor. > java:94) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.NoClassDefFoundError: Could not initialize class > org.apache.kylin.metadata.datatype.DataType > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:328) > at org.apache.kylin.gridtable.GTInfo$1.deserialize(GTInfo. > java:283) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:322) > at org.apache.kylin.gridtable.GTScanRequest$2.deserialize( > GTScanRequest.java:295) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:189) > at org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod( > CubeVisitProtos.java:4353) > at org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:5602) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execServiceOnRegion(HRegionServer.java:3416) > at org.apache.hadoop.hbase.regionserver.HRegionServer. > execService(HRegionServer.java:3398) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:29591) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > ... 4 more > > at org.apache.hadoop.hbase.ipc.RpcClient.call(RpcClient.java:1457) > at org.apache.hadoop.hbase.ipc.RpcClient.callBlockingMethod( > RpcClient.java:1661) > at org.apache.hadoop.hbase.ipc.RpcClient$ > BlockingRpcChannelImplementation.callBlockingMethod(RpcClient.java:1719) > at org.apache.hadoop.hbase.protobuf.generated. > ClientProtos$ClientService$BlockingStub.execService( > ClientProtos.java:30014) > at org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1623) > ... 14 more > 2016-08-19 13:24:55,866 ERROR [pool-8-thread-9] > v2.CubeHBaseEndpointRPC:404 : <sub-thread for GTScanRequest 80b872a> Error > when visiting cubes by endpoint
