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 <[email protected]>: > “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, "王峰" <[email protected]> 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(DefaultLoginPageGeneratingFilter.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.SecurityContextPersistenceFilter.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 <[email protected]>: > > > OK, then please provide more exception information. > > > > On 8/4/16, 11:49 AM, "王峰" <[email protected]> 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 <[email protected]>: > > > > > 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" <[email protected]> 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. > > > > > > > > > > > > > > > > > >
