> hbase-1.0.1 We had a couple of reports that Kylin does not work well with hbase-1.0.x
Suggest upgrade hbase to 1.1.3+ or downgrade to 0.98 Yang On Thu, Aug 4, 2016 at 1:26 PM, 王峰 <wangfengfight...@gmail.com> wrote: > I exec "$KYLIN_HOME/bin/kylin.sh > org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI > $KYLIN_HOME/lib/kylin-coprocessor-*.jar all" > > and echo as follows : Is looks like sucess...but I still can not qurey cube > ==============================================echo========== > ======================================= > 2016-08-04 12:38:56,556 INFO [main-SendThread( > ksdc-s3.intra.knownsec.com:2181) ClientCnxn:1235]: Session establishment > complete on server ksdc-s3.intra.knownsec.com/1$ > .255.5.103:2181, sessionid = 0x354f2d3910ee6a8, negotiated timeout = 40000 > 2016-08-04 12:38:56,623 INFO [main DeployCoprocessorCLI:85]: Identify > coprocessor jar > /home/users/wangf4/kylin-1.5.3-HBase1.x/lib/kylin-coprocessor-1.5.3.jar > 2016-08-04 12:38:56,631 INFO [main CubeManager:132]: Initializing > CubeManager with config kylin_metadata@hbase > 2016-08-04 12:38:56,634 INFO [main ResourceStore:80]: Using metadata url > kylin_metadata@hbase for resource store > 2016-08-04 12:38:56,820 DEBUG [main HBaseConnection:238]: HTable > 'kylin_metadata' already exists > 2016-08-04 12:38:56,883 INFO [main CubeManager:813]: Loading Cube from > folder kylin_metadata(key='/cube')@kylin_metadata@hbase > 2016-08-04 12:38:57,063 INFO [main CubeDescManager:91]: Initializing > CubeDescManager with config kylin_metadata@hbase > 2016-08-04 12:38:57,063 INFO [main CubeDescManager:197]: Reloading Cube > Metadata from folder kylin_metadata(key='/cube_desc')@kylin_metadata@hbase > 2016-08-04 12:38:57,112 DEBUG [main MetadataManager:311]: Reloading > SourceTable from folder kylin_metadata(key='/table')@kylin_metadata@hbase > 2016-08-04 12:38:57,184 DEBUG [main MetadataManager:320]: Loaded 6 > SourceTable(s) > 2016-08-04 12:38:57,184 DEBUG [main MetadataManager:252]: Reloading > SourceTable exd info from folder > kylin_metadata(key='/table_exd')@kylin_metadata@hbase > 2016-08-04 12:38:57,199 DEBUG [main MetadataManager:261]: Loaded 3 > SourceTable EXD(s) > 2016-08-04 12:38:57,199 DEBUG [main MetadataManager:412]: Reloading > DataModel from folder kylin_metadata(key='/model_ > desc')@kylin_metadata@hbase > 2016-08-04 12:38:57,222 DEBUG [main MetadataManager:426]: Loaded 1 > DataModel(s) > 2016-08-04 12:38:57,222 DEBUG [main MetadataManager:297]: Reloading > ExternalFilter from folder > kylin_metadata(key='/ext_filter')@kylin_metadata@hbase > 2016-08-04 12:38:57,226 DEBUG [main MetadataManager:306]: Loaded 0 > ExternalFilter(s) > 2016-08-04 12:38:57,234 DEBUG [main CubeDescManager:222]: Loaded 1 Cube(s) > 2016-08-04 12:38:57,237 DEBUG [main CubeManager:855]: Reloaded new cube: > kylin_sales_cube_desc_clone_clone with reference > beingCUBE[name=kylin_sales_cube_desc_clone_cl$ > ne] having 1 segments:KYLIN_O3IJKXOPI6 > 2016-08-04 12:38:57,237 INFO [main CubeManager:826]: Loaded 1 cubes, fail > on 0 cubes > added new table: KYLIN_O3IJKXOPI6 > 2016-08-04 12:38:57,237 INFO [main DeployCoprocessorCLI:88]: Identify > tables [KYLIN_O3IJKXOPI6] > 2016-08-04 12:38:57,237 INFO [main DeployCoprocessorCLI:99]: Will execute > tables [KYLIN_O3IJKXOPI6] > 2016-08-04 12:38:57,366 INFO [main DeployCoprocessorCLI:102]: Old > coprocessor jar: > [hdfs://ksdc-cluster/users/wangf4/kylin/kylin_hdfs_ > working_dir/kylin_metadata/coproessor/kylin-coprocessor- > 1.5.0-SNAPSHOT-0.jar] > 2016-08-04 12:38:57,414 INFO [main DeployCoprocessorCLI:105]: New > coprocessor jar: > hdfs://ksdc-cluster/users/wangf4/kylin/kylin_hdfs_ > working_dir/kylin_metadata/coproce > ssor/kylin-coprocessor-1.5.3-0.jar > 2016-08-04 12:38:57,415 INFO [main DeployCoprocessorCLI:185]: Disable > KYLIN_O3IJKXOPI6 > 2016-08-04 12:38:57,416 INFO [main HBaseAdmin:978]: Started disable of > KYLIN_O3IJKXOPI6 > 2016-08-04 12:39:00,448 INFO [main HBaseAdmin:1033]: Disabled > KYLIN_O3IJKXOPI6 > 2016-08-04 12:39:00,449 INFO [main DeployCoprocessorCLI:188]: Unset > coprocessor on KYLIN_O3IJKXOPI6 > 2016-08-04 12:39:00,452 INFO [main DeployCoprocessorCLI:179]: Add > coprocessor on KYLIN_O3IJKXOPI6 > 2016-08-04 12:39:00,954 INFO [main DeployCoprocessorCLI:216]: Enable > KYLIN_O3IJKXOPI6 > 2016-08-04 12:39:00,955 INFO [main HBaseAdmin:898]: Started enable of > KYLIN_O3IJKXOPI6 > 2016-08-04 12:39:03,994 INFO [main HBaseAdmin:827]: Enabled table > KYLIN_O3IJKXOPI6 > 2016-08-04 12:39:03,994 INFO [main DeployCoprocessorCLI:114]: Processed > [KYLIN_O3IJKXOPI6] > 2016-08-04 12:39:03,995 INFO [main DeployCoprocessorCLI:115]: Active > coprocessor jar: > hdfs://ksdc-cluster/users/wangf4/kylin/kylin_hdfs_ > working_dir/kylin_metadata/coprocessor/kylin-coprocessor-1.5.3-0.jar > 2016-08-04 12:39:03,996 INFO [Thread-0 > ConnectionManager$HConnectionImplementation:2046]: Closing master > protocol: > MasterService > 2016-08-04 12:39:04,001 INFO [Thread-0 > ConnectionManager$HConnectionImplementation:1682]: Closing zookeeper > sessionid=0x354f2d3910ee6a8 > 2016-08-04 12:39:04,006 INFO [Thread-0 ZooKeeper:684]: Session: > 0x354f2d3910ee6a8 closed > 2016-08-04 12:39:04,006 INFO [main-EventThread ClientCnxn:512]: > EventThread shut down > > > 2016-08-04 12:35 GMT+08:00 Cheng Wang <cheng.w...@kyligence.io>: > > > “Caused by: java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region;” > > > > It’s sure your current hbase is not compatible to kylin. Tty to do this: > > http://kylin.apache.org/docs15/howto/howto_update_coprocessor.html > > > > If it still fails, you might need to update your hbase or to use HDP/CDH > > to make it pass. > > > > > > > > > > On 8/4/16, 12:14 PM, "王峰" <wangfengfight...@gmail.com> wrote: > > > > ok I exec SQL on table "KYLIN_CATEGORY_GROUPINGS" and got Success..like > > this: > > ==========================[QUERY]=============================== > > SQL: select * from KYLIN_CATEGORY_GROUPINGS > > User: ADMIN > > Success: true > > Duration: 0.026 > > Project: learn_kylin > > Realization Names: [kylin_sales_cube_desc_clone_clone] > > Cuboid Ids: [] > > Total scan count: 0 > > Result row count: 144 > > Accept Partial: true > > Is Partial Result: false > > Hit Exception Cache: false > > Storage cache used: false > > Message: null > > ==========================[QUERY]=============================== > > > > 2.select * from KYLIN_SALES Fail: > > > > > > ------------------------------------------------------------ > -------------------------------------------------------- > > 2016-08-04 12:02:00,604 INFO [http-bio-7070-exec-5] > > controller.QueryController:174 : Using project: learn_kylin > > 2016-08-04 12:02:00,604 INFO [http-bio-7070-exec-5] > > controller.QueryController:175 : The original query: select * from > > KYLIN_SALES > > 2016-08-04 12:02:00,605 INFO [http-bio-7070-exec-5] > > service.QueryService:269 : The corrected query: select * from > KYLIN_SALES > > LIMIT 50000 > > 2016-08-04 12:02:00,623 INFO [http-bio-7070-exec-5] > routing.QueryRouter:48 > > : The project manager's reference is > > org.apache.kylin.metadata.project.ProjectManager@1a9b1372 > > 2016-08-04 12:02:00,623 INFO [http-bio-7070-exec-5] > routing.QueryRouter:60 > > : Find candidates by table DEFAULT.KYLIN_SALES and project=LEARN_KYLIN : > > org.apache.kylin.query.routing.Candidate@467295b7 > > 2016-08-04 12:02:00,623 INFO [http-bio-7070-exec-5] > routing.QueryRouter:49 > > : Applying rule: class > > org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule, > > realizations before: [kylin_sales_cube_desc_clone_clone(CUBE)], > > realizations after: [kylin_sales_cube_desc_clone_clone(CUBE)] > > 2016-08-04 12:02:00,623 INFO [http-bio-7070-exec-5] > routing.QueryRouter:49 > > : Applying rule: class > > org.apache.kylin.query.routing.rules.RealizationSortRule, realizations > > before: [kylin_sales_cube_desc_clone_clone(CUBE)], realizations after: > > [kylin_sales_cube_desc_clone_clone(CUBE)] > > 2016-08-04 12:02:00,623 INFO [http-bio-7070-exec-5] > routing.QueryRouter:72 > > : The realizations remaining: [kylin_sales_cube_desc_clone_clone(CUBE)] > And > > the final chosen one is the first one > > 2016-08-04 12:02:00,628 DEBUG [http-bio-7070-exec-5] > > enumerator.OLAPEnumerator:105 : query storage... > > 2016-08-04 12:02:00,628 INFO [http-bio-7070-exec-5] > > enumerator.OLAPEnumerator:170 : No group by and aggregation found in this > > query, will hack some result for better look of output... > > 2016-08-04 12:02:00,628 WARN [http-bio-7070-exec-5] > > enumerator.OLAPEnumerator:205 : SUM is not defined for measure column > > DEFAULT.KYLIN_SALES.SELLER_ID, output will be meaningless. > > 2016-08-04 12:02:00,629 INFO [http-bio-7070-exec-5] > > gtrecord.GTCubeStorageQueryBase:247 : exactAggregation is true > > 2016-08-04 12:02:00,629 INFO [http-bio-7070-exec-5] > > gtrecord.GTCubeStorageQueryBase:365 : Enable limit 50000 > > 2016-08-04 12:02:00,629 DEBUG [http-bio-7070-exec-5] > > v2.CubeHBaseEndpointRPC:271 : New scanner for current segment > > kylin_sales_cube_desc_clone_clone[20120101000000_20160801000000] will > use > > SCAN_FILTER_AGGR_CHECKMEM as endpoint's behavior > > 2016-08-04 12:02:00,630 DEBUG [http-bio-7070-exec-5] > > v2.CubeHBaseEndpointRPC:327 : Serialized scanRequestBytes 829 bytes, > > rawScanBytesString 72 bytes > > 2016-08-04 12:02:00,630 INFO [http-bio-7070-exec-5] > > v2.CubeHBaseEndpointRPC:329 : The scan 324ef549 for segment > > kylin_sales_cube_desc_clone_clone[20120101000000_20160801000000] is as > > below with 1 separate raw scans, shard part of start/end key is set to 0 > > 2016-08-04 12:02:00,630 INFO [http-bio-7070-exec-5] v2.CubeHBaseRPC:271 > : > > Visiting hbase table KYLIN_O3IJKXOPI6: cuboid exact match, from 99 to 99 > > Start: > > > > \x00\x00\x00\x00\x00\x00\x00\x00\x00\x63\x00\x00\x00\x00\ > x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 > > > > (\x00\x00\x00\x00\x00\x00\x00\x00\x00c\x00\x00\x00\x00\x00\ > x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00) > > Stop: > > > > \x00\x00\x00\x00\x00\x00\x00\x00\x00\x63\xFF\xFF\xFF\xFF\ > xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00 > > > > (\x00\x00\x00\x00\x00\x00\x00\x00\x00c\xFF\xFF\xFF\xFF\xFF\ > xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\x00), > > No Fuzzy Key > > 2016-08-04 12:02:00,630 DEBUG [http-bio-7070-exec-5] > > v2.CubeHBaseEndpointRPC:334 : Submitting rpc to 1 shards starting from > > shard 0, scan range count 1 > > 2016-08-04 12:02:00,663 INFO [http-bio-7070-exec-5] > > v2.CubeHBaseEndpointRPC:110 : Timeout for ExpectedSizeIterator is: 990000 > > 2016-08-04 12:02:00,663 DEBUG [http-bio-7070-exec-5] > > enumerator.OLAPEnumerator:122 : return TupleIterator... > > 2016-08-04 12:02:00,667 ERROR [pool-48-thread-6] > > v2.CubeHBaseEndpointRPC:407 : <sub-thread for GTScanRequest 324ef549> > Error > > when visiting cubes by endpoint > > org.apache.hadoop.hbase.DoNotRetryIOException: > > org.apache.hadoop.hbase.DoNotRetryIOException: > java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2062) > > 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:745) > > Caused by: java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:153) > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated. > CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:3800) > > at > > org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:6154) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion( > RSRpcServices.java:1692) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices. > execService(RSRpcServices.java:1674) > > at > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2. > callBlockingMethod(ClientProtos.java:31447) > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > > ... 4 more > > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > at > > > > sun.reflect.NativeConstructorAccessorImpl.newInstance( > NativeConstructorAccessorImpl.java:62) > > at > > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance( > DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > > 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:322) > > at > > > > org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1619) > > 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.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:374) > > at > > > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$1$1.call( > CubeHBaseEndpointRPC.java:370) > > at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1741) > > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > > at > > > > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142) > > at > > > > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:617) > > at java.lang.Thread.run(Thread.java:745) > > Caused by: > > > > org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org. > apache.hadoop.hbase.DoNotRetryIOException): > > org.apache.hadoop.hbase.DoNotRetryIOException: > java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2062) > > 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:745) > > Caused by: java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:153) > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated. > CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:3800) > > at > > org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:6154) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion( > RSRpcServices.java:1692) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices. > execService(RSRpcServices.java:1674) > > at > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2. > callBlockingMethod(ClientProtos.java:31447) > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > > ... 4 more > > > > at org.apache.hadoop.hbase.ipc.RpcClientImpl.call( > RpcClientImpl.java:1206) > > at > > > > org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod( > AbstractRpcClient.java:213) > > at > > > > org.apache.hadoop.hbase.ipc.AbstractRpcClient$ > BlockingRpcChannelImplementation.callBlockingMethod( > AbstractRpcClient.java:287) > > at > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$ > BlockingStub.execService(ClientProtos.java:32675) > > at > > > > org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1615) > > ... 13 more > > 2016-08-04 12:02:05,664 ERROR [http-bio-7070-exec-5] > > controller.QueryController:209 : Exception when execute sql > > java.sql.SQLException: Error while executing SQL "select * from > > KYLIN_SALES > > LIMIT 50000": Error in coprocessor > > at org.apache.calcite.avatica.Helper.createException(Helper.java:56) > > at org.apache.calcite.avatica.Helper.createException(Helper.java:41) > > at > > > > org.apache.calcite.avatica.AvaticaStatement.executeInternal( > AvaticaStatement.java:143) > > at > > > > org.apache.calcite.avatica.AvaticaStatement.executeQuery( > AvaticaStatement.java:186) > > at > > org.apache.kylin.rest.service.QueryService.execute( > QueryService.java:364) > > at > > > > org.apache.kylin.rest.service.QueryService.queryWithSqlMassage( > QueryService.java:276) > > at org.apache.kylin.rest.service.QueryService.query( > QueryService.java:121) > > at > > > > org.apache.kylin.rest.service.QueryService$$FastClassByCGLIB$$4957273f. > invoke(<generated>) > > at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) > > at > > > > org.springframework.aop.framework.Cglib2AopProxy$ > DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618) > > at > > > > org.apache.kylin.rest.service.QueryService$$EnhancerByCGLIB$ > $1c574fd4.query(<generated>) > > at > > > > org.apache.kylin.rest.controller.QueryController.doQueryWithCache( > QueryController.java:192) > > at > > > > org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:94) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > > > sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > at > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at > > > > org.springframework.web.method.support.InvocableHandlerMethod.invoke( > InvocableHandlerMethod.java:213) > > at > > > > org.springframework.web.method.support.InvocableHandlerMethod. > invokeForRequest(InvocableHandlerMethod.java:126) > > at > > > > org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:96) > > at > > > > org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandlerMethod( > RequestMappingHandlerAdapter.java:617) > > at > > > > org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter. > java:578) > > at > > > > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter. > handle(AbstractHandlerMethodAdapter.java:80) > > at > > > > org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:923) > > at > > > > org.springframework.web.servlet.DispatcherServlet. > doService(DispatcherServlet.java:852) > > at > > > > org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:882) > > at > > > > org.springframework.web.servlet.FrameworkServlet. > doPost(FrameworkServlet.java:789) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:303) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > > at org.apache.tomcat.websocket.server.WsFilter.doFilter( > WsFilter.java:52) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:241) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:330) > > at > > > > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) > > at > > > > org.springframework.security.web.access.intercept. > FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.access.ExceptionTranslationFilter. > doFilter(ExceptionTranslationFilter.java:113) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.session.SessionManagementFilter. > doFilter(SessionManagementFilter.java:103) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.authentication. > AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter. > java:113) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.servletapi. > SecurityContextHolderAwareRequestFilter.doFilter( > SecurityContextHolderAwareRequestFilter.java:54) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.savedrequest.RequestCacheAwareFilter. > doFilter(RequestCacheAwareFilter.java:45) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.authentication.www. > BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.authentication.ui. > DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt > er.java:91) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.authentication. > AbstractAuthenticationProcessingFilter.doFilter( > AbstractAuthenticationProcessingFilter.java:183) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.authentication.logout. > LogoutFilter.doFilter(LogoutFilter.java:105) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.context.SecurityContextPersistenceFilt > er.doFilter(SecurityContextPersistenceFilter.java:87) > > at > > > > org.springframework.security.web.FilterChainProxy$ > VirtualFilterChain.doFilter(FilterChainProxy.java:342) > > at > > > > org.springframework.security.web.FilterChainProxy.doFilterInternal( > FilterChainProxy.java:192) > > at > > > > org.springframework.security.web.FilterChainProxy.doFilter( > FilterChainProxy.java:160) > > at > > > > org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate( > DelegatingFilterProxy.java:346) > > at > > > > org.springframework.web.filter.DelegatingFilterProxy.doFilter( > DelegatingFilterProxy.java:259) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:241) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > > at com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:195) > > at com.thetransactioncompany.cors.CORSFilter.doFilter( > CORSFilter.java:266) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > ApplicationFilterChain.java:241) > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter( > ApplicationFilterChain.java:208) > > at > > > > org.apache.catalina.core.StandardWrapperValve.invoke( > StandardWrapperValve.java:220) > > at > > > > org.apache.catalina.core.StandardContextValve.invoke( > StandardContextValve.java:122) > > at > > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke( > AuthenticatorBase.java:505) > > at > > > > org.apache.catalina.core.StandardHostValve.invoke( > StandardHostValve.java:169) > > at > > > > org.apache.catalina.valves.ErrorReportValve.invoke( > ErrorReportValve.java:103) > > at > > org.apache.catalina.valves.AccessLogValve.invoke( > AccessLogValve.java:956) > > at > > > > org.apache.catalina.core.StandardEngineValve.invoke( > StandardEngineValve.java:116) > > at > > org.apache.catalina.connector.CoyoteAdapter.service( > CoyoteAdapter.java:436) > > at > > > > org.apache.coyote.http11.AbstractHttp11Processor.process( > AbstractHttp11Processor.java:1078) > > at > > > > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler. > process(AbstractProtocol.java:625) > > at > > > > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor. > run(JIoEndpoint.java:318) > > at > > > > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142) > > at > > > > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:617) > > at > > > > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run( > TaskThread.java:61) > > at java.lang.Thread.run(Thread.java:745) > > Caused by: java.lang.RuntimeException: Error in coprocessor > > at > > > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ > ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:134) > > at > > > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$ > ExpectedSizeIterator.next(CubeHBaseEndpointRPC.java:85) > > at > > > > com.google.common.collect.TransformedIterator.next( > TransformedIterator.java:48) > > at com.google.common.collect.Iterators$6.hasNext(Iterators.java:583) > > at > > > > org.apache.kylin.storage.gtrecord.SequentialCubeTupleIterator.hasNext( > SequentialCubeTupleIterator.java:100) > > at > > > > org.apache.kylin.query.enumerator.OLAPEnumerator. > moveNext(OLAPEnumerator.java:72) > > at > > > > org.apache.calcite.linq4j.EnumerableDefaults$ > TakeWhileEnumerator.moveNext(EnumerableDefaults.java:2818) > > at > > org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.< > init>(Linq4j.java:664) > > at org.apache.calcite.linq4j.Linq4j.enumeratorIterator(Linq4j.java:98) > > at > > > > org.apache.calcite.linq4j.AbstractEnumerable.iterator( > AbstractEnumerable.java:33) > > at org.apache.calcite.avatica.MetaImpl.createCursor(MetaImpl.java:85) > > at > > > > org.apache.calcite.avatica.AvaticaResultSet.execute( > AvaticaResultSet.java:190) > > at > > org.apache.calcite.jdbc.CalciteResultSet.execute( > CalciteResultSet.java:65) > > at > > org.apache.calcite.jdbc.CalciteResultSet.execute( > CalciteResultSet.java:44) > > at > > > > org.apache.calcite.avatica.AvaticaConnection$1.execute( > AvaticaConnection.java:566) > > at > > > > org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute( > CalciteMetaImpl.java:578) > > at > > > > org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal( > AvaticaConnection.java:571) > > at > > > > org.apache.calcite.avatica.AvaticaStatement.executeInternal( > AvaticaStatement.java:135) > > ... 80 more > > Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: > > org.apache.hadoop.hbase.DoNotRetryIOException: > java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2062) > > 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:745) > > Caused by: java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:153) > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated. > CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:3800) > > at > > org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:6154) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion( > RSRpcServices.java:1692) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices. > execService(RSRpcServices.java:1674) > > at > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2. > callBlockingMethod(ClientProtos.java:31447) > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > > ... 4 more > > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > > at > > > > sun.reflect.NativeConstructorAccessorImpl.newInstance( > NativeConstructorAccessorImpl.java:62) > > at > > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance( > DelegatingConstructorAccessorImpl.java:45) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > > 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:322) > > at > > > > org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1619) > > 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.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:374) > > at > > > > org.apache.kylin.storage.hbase.cube.v2.CubeHBaseEndpointRPC$1$1.call( > CubeHBaseEndpointRPC.java:370) > > at org.apache.hadoop.hbase.client.HTable$16.call(HTable.java:1741) > > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > > at > > > > java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142) > > at > > > > java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:617) > > ... 1 more > > Caused by: > > > > org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org. > apache.hadoop.hbase.DoNotRetryIOException): > > org.apache.hadoop.hbase.DoNotRetryIOException: > java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2062) > > 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:745) > > Caused by: java.lang.NoSuchMethodError: > > > > org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment. > getRegion()Lorg/apache/hadoop/hbase/regionserver/Region; > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor. > endpoint.CubeVisitService.visitCube(CubeVisitService.java:153) > > at > > > > org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated. > CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:3800) > > at > > org.apache.hadoop.hbase.regionserver.HRegion. > execService(HRegion.java:6154) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion( > RSRpcServices.java:1692) > > at > > > > org.apache.hadoop.hbase.regionserver.RSRpcServices. > execService(RSRpcServices.java:1674) > > at > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2. > callBlockingMethod(ClientProtos.java:31447) > > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2031) > > ... 4 more > > > > at org.apache.hadoop.hbase.ipc.RpcClientImpl.call( > RpcClientImpl.java:1206) > > at > > > > org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod( > AbstractRpcClient.java:213) > > at > > > > org.apache.hadoop.hbase.ipc.AbstractRpcClient$ > BlockingRpcChannelImplementation.callBlockingMethod( > AbstractRpcClient.java:287) > > at > > > > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$ > BlockingStub.execService(ClientProtos.java:32675) > > at > > > > org.apache.hadoop.hbase.protobuf.ProtobufUtil. > execService(ProtobufUtil.java:1615) > > ... 13 more > > 2016-08-04 12:02:05,665 INFO [http-bio-7070-exec-5] > > service.QueryService:253 : > > ==========================[QUERY]=============================== > > SQL: select * from KYLIN_SALES > > User: ADMIN > > Success: false > > Duration: 0.0 > > Project: learn_kylin > > Realization Names: [kylin_sales_cube_desc_clone_clone] > > Cuboid Ids: [99] > > Total scan count: 0 > > Result row count: 0 > > Accept Partial: true > > Is Partial Result: false > > Hit Exception Cache: false > > Storage cache used: false > > Message: Error while executing SQL "select * from KYLIN_SALES LIMIT > > 50000": Error in coprocessor > > ==========================[QUERY]=============================== > > > > > > > > > > > > > > ============================================================ > ======================================= > > > > I really have no idea ... thanks for your help > > > > ============================================================ > =============================== > > > > > > > > 2016-08-04 11:56 GMT+08:00 Cheng Wang <cheng.w...@kyligence.io>: > > > > > OK, then please provide more exception information. > > > > > > On 8/4/16, 11:49 AM, "王峰" <wangfengfight...@gmail.com> wrote: > > > > > > sorry I am not describe rightly , my kylin version is > > > apache-kylin-1.5.3-HBase1.x-bin. > > > I did not use apache-kylin-1.5.3-bin.tar.gz ... > > > > > > 2016-08-04 11:37 GMT+08:00 Cheng Wang <cheng.w...@kyligence.io>: > > > > > > > I meant that you need to check your Kylin version. According to your > > > > environment, try this version: > > > > > > > > > http://www.apache.org/dyn/closer.cgi/kylin/apache-kylin- > 1.5.3/apache-kylin-1.5.3-HBase1.x-bin.tar.gz > > > > > > > > On 8/4/16, 11:03 AM, "wangfeng" <wangfengfight...@gmail.com> wrote: > > > > > > > > as you say, I check the details logs of kylin-1.5.3,and found those > > info: > > > > ==========================[QUERY]=============================== > > > > SQL: select * from KYLIN_SALES > > > > User: ADMIN > > > > Success: false > > > > Duration: 0.0 > > > > Project: learn_kylin > > > > Realization Names: [kylin_sales_cube_desc_clone_clone] > > > > Cuboid Ids: [99] > > > > Total scan count: 0 > > > > Result row count: 0 > > > > Accept Partial: true > > > > Is Partial Result: false > > > > Hit Exception Cache: false > > > > Storage cache used: false > > > > Message: Error while executing SQL "select * from KYLIN_SALES LIMIT > > > 50000": > > > > Error in coprocessor > > > > ==========================[QUERY]=============================== > > > > > > > > 2016-08-04 10:53:11,819 ERROR [http-bio-7070-exec-10] > > > > controller.BasicController:44 : > > > > org.apache.kylin.rest.exception.InternalErrorException: Error while > > > > executing SQL "select * from KYLIN_SALES LIMIT 50000": Error in > > > coprocessor > > > > at > > > > > > > > > > > > > org.apache.kylin.rest.controller.QueryController.doQueryWithCache( > QueryController.java:224) > > > > at > > > > > > > > > > > > > org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:94) > > > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > > > > at > > > > > > > > > > > > > sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:62) > > > > at > > > > > > > > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > > > > at java.lang.reflect.Method.invoke(Method.java:498) > > > > at > > > > > > > > > > > > > org.springframework.web.method.support.InvocableHandlerMethod.invoke( > InvocableHandlerMethod.java:213) > > > > at > > > > > > > > > > > > > org.springframework.web.method.support.InvocableHandlerMethod. > invokeForRequest(InvocableHandlerMethod.java:126) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.mvc.method.annotation. > ServletInvocableHandlerMethod.invokeAndHandle( > ServletInvocableHandlerMethod.java:96) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.invokeHandlerMethod( > RequestMappingHandlerAdapter.java:617) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.mvc.method.annotation. > RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter. > java:578) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter. > handle(AbstractHandlerMethodAdapter.java:80) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.DispatcherServlet. > doDispatch(DispatcherServlet.java:923) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.DispatcherServlet. > doService(DispatcherServlet.java:852) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.FrameworkServlet.processRequest( > FrameworkServlet.java:882) > > > > at > > > > > > > > > > > > > org.springframework.web.servlet.FrameworkServlet. > doPost(FrameworkServlet.java:789) > > > > > > > > > > > > > ------------------------------------------------------------ > ------------------------------------------------------------ > ---------------------------------- > > > > > > > > if hbase version 0.98 works well , can I compile the > > > > kylin-coprocessor-1.5.3-0.jar to meet the 0.98. > > > > btw, I used to set coprocessor to > > > > kylin-1.5---kylin-coprocessor-1.5.0-SNAPSHOT-0.jar but did not > > work..... > > > > > > > > -- > > > > View this message in context: > > > > > > > > > http://apache-kylin.74782.x6.nabble.com/cube-query-problem- > with-kylin-1-5-3-tp5484p5490.html > > > > Sent from the Apache Kylin mailing list archive at Nabble.com. > > > > > > > > > > > > > > > > > > > > > > > > > > > >
