Cannot figure out the root cause according to the info provided. Would you please follow the following guide to generate diagnosis package?
http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/ Apache Kylin | Diagnosis Tool Introduction<http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/> kylin.apache.org Diagnosis Tool Introduction. Jun 10, 2016 ?6?1 Dong Li. Introduction. Since Apache Kylin 1.5.2, there??s a diagnosis tool on Web UI, which aims to help Kylin admins ... ________________________________ ??????: 35925138 <[email protected]> ????????: 2017??4??28?? 10:12:17 ??????: dev ????: ??????????: Error while executing SQL "select count(*) as nums,courseid from optionaction group by courseid LIMIT 50000": null ?????? ???????????????? 2017-04-28 10:08:47,001 ERROR [http-bio-7070-exec-6] controller.BasicController:44 : org.apache.kylin.rest.exception.InternalErrorException: Error while executing SQL "select count(*) as nums,fdz from optionaction group by fdz LIMIT 50000": null at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:389) at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69) 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:483) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827) 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:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) 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: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:316) 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) cube ??json?????? { "uuid": "9bc80d90-4bf2-4ae5-b3ee-dd8a563fcefd", "last_modified": 1493263501742, "version": "1.6.0", "name": "aaabbb", "model_name": "optionaction", "description": "", "null_string": null, "dimensions": [ { "name": "ACTION_TIME", "table": "DEFAULT.OPTIONACTION", "column": "ACTION_TIME", "derived": null }, { "name": "AGENTID", "table": "DEFAULT.OPTIONACTION", "column": "AGENTID", "derived": null }, { "name": "COURSEID", "table": "DEFAULT.OPTIONACTION", "column": "COURSEID", "derived": null }, { "name": "COURSEVERSION", "table": "DEFAULT.OPTIONACTION", "column": "COURSEVERSION", "derived": null }, { "name": "IP", "table": "DEFAULT.OPTIONACTION", "column": "IP", "derived": null }, { "name": "DAY_TIME", "table": "DEFAULT.OPTIONACTION", "column": "DAY_TIME", "derived": null }, { "name": "HOUR_TIME", "table": "DEFAULT.OPTIONACTION", "column": "HOUR_TIME", "derived": null }, { "name": "MONTH_TIME", "table": "DEFAULT.OPTIONACTION", "column": "MONTH_TIME", "derived": null }, { "name": "YEAR_TIME", "table": "DEFAULT.OPTIONACTION", "column": "YEAR_TIME", "derived": null }, { "name": "RESTYPE", "table": "DEFAULT.OPTIONACTION", "column": "RESTYPE", "derived": null }, { "name": "RESID", "table": "DEFAULT.OPTIONACTION", "column": "RESID", "derived": null }, { "name": "USERID", "table": "DEFAULT.OPTIONACTION", "column": "USERID", "derived": null }, { "name": "SEX", "table": "DEFAULT.OPTIONACTION", "column": "SEX", "derived": null }, { "name": "AGE", "table": "DEFAULT.OPTIONACTION", "column": "AGE", "derived": null }, { "name": "RX_PICI", "table": "DEFAULT.OPTIONACTION", "column": "RX_PICI", "derived": null }, { "name": "STUDYKIND", "table": "DEFAULT.OPTIONACTION", "column": "STUDYKIND", "derived": null }, { "name": "SUBJECT", "table": "DEFAULT.OPTIONACTION", "column": "SUBJECT", "derived": null }, { "name": "FDZ", "table": "DEFAULT.OPTIONACTION", "column": "FDZ", "derived": null }, { "name": "PROVINCENAME", "table": "DEFAULT.OPTIONACTION", "column": "PROVINCENAME", "derived": null }, { "name": "CITYNAME", "table": "DEFAULT.OPTIONACTION", "column": "CITYNAME", "derived": null } ], "measures": [ { "name": "_COUNT_", "function": { "expression": "COUNT", "parameter": { "type": "constant", "value": "1", "next_parameter": null }, "returntype": "bigint" }, "dependent_measure_ref": null } ], "dictionaries": [], "rowkey": { "rowkey_columns": [ { "column": "ACTION_TIME", "encoding": "time", "isShardBy": false }, { "column": "AGENTID", "encoding": "dict", "isShardBy": false }, { "column": "COURSEID", "encoding": "dict", "isShardBy": false }, { "column": "COURSEVERSION", "encoding": "dict", "isShardBy": false }, { "column": "IP", "encoding": "dict", "isShardBy": false }, { "column": "DAY_TIME", "encoding": "dict", "isShardBy": false }, { "column": "HOUR_TIME", "encoding": "dict", "isShardBy": false }, { "column": "MONTH_TIME", "encoding": "dict", "isShardBy": false }, { "column": "YEAR_TIME", "encoding": "dict", "isShardBy": false }, { "column": "RESTYPE", "encoding": "dict", "isShardBy": false }, { "column": "RESID", "encoding": "dict", "isShardBy": false }, { "column": "USERID", "encoding": "dict", "isShardBy": false }, { "column": "SEX", "encoding": "dict", "isShardBy": false }, { "column": "AGE", "encoding": "dict", "isShardBy": false }, { "column": "RX_PICI", "encoding": "dict", "isShardBy": false }, { "column": "STUDYKIND", "encoding": "dict", "isShardBy": false }, { "column": "SUBJECT", "encoding": "dict", "isShardBy": false }, { "column": "FDZ", "encoding": "dict", "isShardBy": false }, { "column": "PROVINCENAME", "encoding": "dict", "isShardBy": false }, { "column": "CITYNAME", "encoding": "dict", "isShardBy": false } ] }, "hbase_mapping": { "column_family": [ { "name": "F1", "columns": [ { "qualifier": "M", "measure_refs": [ "_COUNT_" ] } ] } ] }, "aggregation_groups": [ { "includes": [ "ACTION_TIME", "AGENTID", "COURSEID", "COURSEVERSION", "YEAR_TIME", "RESTYPE", "RESID", "USERID", "FDZ" ], "select_rule": { "hierarchy_dims": [], "mandatory_dims": [ "ACTION_TIME", "AGENTID", "COURSEID", "COURSEVERSION", "YEAR_TIME", "RESID", "USERID", "FDZ", "RESTYPE" ], "joint_dims": [] } } ], "signature": "OAQ2Qt6vo4CWuAstfTJ4qg==", "notify_list": [], "status_need_notify": [ "ERROR", "SUCCEED" ], "partition_date_start": 1491436800000, "partition_date_end": 3153600000000, "auto_merge_time_ranges": [ 604800000, 2419200000 ], "retention_range": 0, "engine_type": 2, "storage_type": 2, "override_kylin_properties": {} } ------------------ ???????? ------------------ ??????: "roger shi";<[email protected]>; ????????: 2017??4??27??(??????) ????1:46 ??????: "dev"<[email protected]>; ????: ????: Error while executing SQL "select count(*) as nums,courseid from optionaction group by courseid LIMIT 50000": null More information is required to answer your question. Would you mind to attach kylin log and related metadata json? ________________________________ ??????: 35925138 <[email protected]> ????????: 2017??4??27?? 11:32:44 ??????: dev ????: Error while executing SQL "select count(*) as nums,courseid from optionaction group by courseid LIMIT 50000": null ?????? ??????????cube????????????????????????????????sql??????????null ????????????????????????????????????cube?? ????kylin??????1.6.0
