SELECT SUM(price) FROM kylin_sales LIMIT 50000 jdk-8u191-linux-x64.tar.gz zookeeper-3.4.5.tar.gz hadoop-2.7.7.tar.gz hbase-1.1.1-bin.tar.gz hbase-1.5.0-bin.tar.gz apache-hive-1.2.1-bin.tar.gz apache-kylin-2.5.2-bin-hbase1x.tar.gz apache-kylin-2.6.4-bin-hbase1x.tar.gz ==========================[QUERY]=============================== Query Id: 35a23341-2b08-e32f-4cbc-42348eceec51 SQL: SELECT SUM(price) FROM kylin_sales User: ADMIN Success: false Duration: 0.228 Project: learn_kylin Realization Names: [CUBE[name=kylin_sales_cube]] Cuboid Ids: [16384] Total scan count: 0 Total scan bytes: 0 Result row count: 0 Accept Partial: true Is Partial Result: false Hit Exception Cache: false Storage cache used: false Is Query Push-Down: false Is Prepare: false Trace URL: null Message: org.apache.hadoop.hbase.exceptions.UnknownProtocolException: org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No registered coprocessor service found for name CubeVisitService in region KYLIN_QLF9A6GPM7,,1575951985092.4ff8b4d4f0ddcfef105bf518e25a30cb. at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7367) at org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1873) at org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1855) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32209) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101) 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:748) while executing SQL: "SELECT SUM(price) FROM kylin_sales LIMIT 50000" ==========================[QUERY]=============================== 2019-12-10 15:46:26,081 ERROR [http-bio-7070-exec-3] controller.BasicController:63 : org.apache.kylin.rest.exception.InternalErrorException: org.apache.hadoop.hbase.exceptions.UnknownProtocolException: org.apache.hadoop.hbase.exceptions.UnknownProtocolException: No registered coprocessor service found for name CubeVisitService in region KYLIN_QLF9A6GPM7,,1575951985092.4ff8b4d4f0ddcfef105bf518e25a30cb. at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7367) at org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1873) at org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1855) at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32209) at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2112) at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101) 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:748) while executing SQL: "SELECT SUM(price) FROM kylin_sales LIMIT 50000" at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:449) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:375) at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93) 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.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) 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:317) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) 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:209) at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) 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:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:1025) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1137) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) $KYLIN_HOME/bin/kylin.sh org.apache.kylin.storage.hbase.util.DeployCoprocessorCLI $KYLIN_HOME/lib/kylin-coprocessor-*.jar all 2019-12-10 15:16:35,423 INFO [main] model.DataModelManager:185 : Model kylin_sales_model is missing or unloaded yet 2019-12-10 15:16:35,424 INFO [main] model.DataModelManager:185 : Model kylin_streaming_model is missing or unloaded yet 2019-12-10 15:16:35,439 INFO [main] model.DataModelManager:185 : Model kylin_streaming_model is missing or unloaded yet 2019-12-10 15:16:35,440 DEBUG [main] cachesync.CachedCrudAssist:127 : Loaded 2 DataModelDesc(s) out of 2 resource 2019-12-10 15:16:35,482 DEBUG [main] cachesync.CachedCrudAssist:127 : Loaded 2 CubeDesc(s) out of 2 resource 2019-12-10 15:16:35,485 DEBUG [main] cachesync.CachedCrudAssist:127 : Loaded 2 CubeInstance(s) out of 2 resource added new table: KYLIN_QLF9A6GPM7 added new table: KYLIN_8Z1ZICB77K 2019-12-10 15:16:35,486 INFO [main] util.DeployCoprocessorCLI:105 : Identify tables [KYLIN_QLF9A6GPM7, KYLIN_8Z1ZICB77K] 2019-12-10 15:16:35,486 INFO [main] util.DeployCoprocessorCLI:117 : Tables after filtering by type all: [KYLIN_QLF9A6GPM7, KYLIN_8Z1ZICB77K] 2019-12-10 15:16:35,492 INFO [main] util.DeployCoprocessorCLI:197 : Commit Information: 2ab5f8076b49468bdfed3d7b5ce6dd71822d9e22; 2019-12-10 15:16:35,507 INFO [main] util.DeployCoprocessorCLI:207 : Filtered tables don't need to deploy coprocessors: [KYLIN_QLF9A6GPM7, KYLIN_8Z1ZICB77K] 2019-12-10 15:16:35,507 INFO [main] util.DeployCoprocessorCLI:120 : Will execute tables [] 2019-12-10 15:16:35,507 INFO [main] util.DeployCoprocessorCLI:125 : Old coprocessor jar: [] 2019-12-10 15:16:35,610 INFO [main] util.DeployCoprocessorCLI:128 : New coprocessor jar: hdfs://node21:9000/kylin/kylin_metadata/coprocessor/kylin-coprocessor-2.6.4-0.jar 2019-12-10 15:16:35,611 INFO [main] util.DeployCoprocessorCLI:358 : Use 8 threads to do upgrade 2019-12-10 15:16:35,611 INFO [main] util.DeployCoprocessorCLI:136 : Processed time: 104 2019-12-10 15:16:35,611 INFO [main] util.DeployCoprocessorCLI:137 : Processed tables count: 0 2019-12-10 15:16:35,612 INFO [main] util.DeployCoprocessorCLI:138 : Processed tables: [] 2019-12-10 15:16:35,612 ERROR [main] util.DeployCoprocessorCLI:139 : Failed tables count: 0 2019-12-10 15:16:35,612 ERROR [main] util.DeployCoprocessorCLI:140 : Failed tables : [] 2019-12-10 15:16:35,612 INFO [main] util.DeployCoprocessorCLI:141 : Active coprocessor jar: hdfs://node21:9000/kylin/kylin_metadata/coprocessor/kylin-coprocessor-2.6.4-0.jar 2019-12-10 15:16:35,616 INFO [close-hbase-conn] hbase.HBaseConnection:136 : Closing HBase connections... 2019-12-10 15:16:35,617 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:2068 : Closing master protocol: MasterService 2019-12-10 15:16:35,617 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:1676 : Closing zookeeper sessionid=0x26eed7a5ccf0016 2019-12-10 15:16:35,625 INFO [close-hbase-conn] zookeeper.ZooKeeper:684 : Session: 0x26eed7a5ccf0016 closed 2019-12-10 15:16:35,626 INFO [main-EventThread] zookeeper.ClientCnxn:512 : EventThread shut down 2019-12-10 15:16:35,727 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:2068 : Closing master protocol: MasterService 2019-12-10 15:16:35,729 INFO [close-hbase-conn] client.ConnectionManager$HConnectionImplementation:1676 : Closing zookeeper sessionid=0x16eed7a5cc70013 2019-12-10 15:16:35,735 INFO [close-hbase-conn] zookeeper.ZooKeeper:684 : Session: 0x16eed7a5cc70013 closed 2019-12-10 15:16:35,735 INFO [main-EventThread] zookeeper.ClientCnxn:512 : EventThread shut down