??????
????????????????
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
