You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Billy Liu <bi...@apache.org> on 2017/05/10 09:40:25 UTC
Re: java.sql.SQLException: Error while executing SQL "select count(*)
from optionaction LIMIT 50000": null
You hit the issue https://issues.apache.org/jira/browse/KYLIN-1749
It's not about how the filter defines, but the mandatory dimension chosen.
2017-05-10 15:50 GMT+08:00 35925138 <35...@qq.com>:
> 能告诉我产生这个错误可能的原因也可以。
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "35925138";<35...@qq.com>;
> 发送时间: 2017年5月10日(星期三) 下午3:46
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: java.sql.SQLException: Error while executing SQL "select count(*)
> from optionaction LIMIT 50000": null
>
>
>
> 各位大牛: 各位大牛,这个问题我之前遇见过一次,因为我的model 里的 filter
> 里,写了如下条件:userid!='',我把这个修改成了 userid<>''
> 就解决了,但是现在,我重新建了一次optionaction表,这个问题又回来,不过这次我就算把filter清空了,仍然有这个问题出现,我对表的操作一个是将原来的第一个字段的类型由string,
> 修改成了int,另外将原来hbase 中的数据不存在的字段,给了一个默认的值'--',其他的就没有什么操作。每次执行与聚合相关的sql,
> 都会报这么一个错误,我现在实在是不清楚为什么会报这样的错误,谁能给指点一下,
> 日志如下:
> 2017-05-10 15:30:51,275 ERROR [Query 7d8bc954-4fad-4cea-ad98-46a248e28324-81]
> service.QueryService:372 : Exception when execute sql
> java.sql.SQLException: Error while executing SQL "select count(*) from
> optionaction
> LIMIT 50000": null
> 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:147)
> at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> AvaticaStatement.java:208)
> at org.apache.kylin.rest.service.QueryService.execute(
> QueryService.java:538)
> at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(
> QueryService.java:452)
> at org.apache.kylin.rest.service.QueryService.query(
> QueryService.java:151)
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:354)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown Source)
> 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:150)
> 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.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.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)
> Caused by: java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:854)
> at java.util.Collections.min(Collections.java:635)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:217)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:141)
> at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
> at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.
> java:68)
> at org.apache.kylin.storage.gtrecord.
> GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> queryStorage(OLAPEnumerator.java:114)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> moveNext(OLAPEnumerator.java:65)
> at Baz$1$1.moveNext(Unknown Source)
> at org.apache.calcite.linq4j.EnumerableDefaults.aggregate(
> EnumerableDefaults.java:116)
> at org.apache.calcite.linq4j.DefaultEnumerable.aggregate(
> DefaultEnumerable.java:107)
> at Baz.bind(Unknown Source)
> at org.apache.calcite.jdbc.CalcitePrepare$
> CalciteSignature.enumerable(CalcitePrepare.java:327)
> at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(
> CalciteConnectionImpl.java:282)
> at org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(
> CalciteMetaImpl.java:553)
> at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(
> CalciteMetaImpl.java:544)
> at org.apache.calcite.avatica.AvaticaResultSet.execute(
> AvaticaResultSet.java:187)
> 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:605)
> at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(
> CalciteMetaImpl.java:599)
> at org.apache.calcite.avatica.AvaticaConnection.
> prepareAndExecuteInternal(AvaticaConnection.java:613)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:139)
> ... 76 more
> 2017-05-10 15:30:51,276 INFO [Query 7d8bc954-4fad-4cea-ad98-46a248e28324-81]
> service.QueryService:284 :
> ==========================[QUERY]===============================
> Query Id: 7d8bc954-4fad-4cea-ad98-46a248e28324
> SQL: select count(*) from optionaction
> LIMIT 50000
> User: ADMIN
> Success: false
> Duration: 0.0
> Project: optionaction
> Realization Names: [fff]
> Cuboid Ids: []
> 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 count(*) from optionaction
> LIMIT 50000": null
> ==========================[QUERY]===============================
>
>
> 2017-05-10 15:30:51,276 ERROR [http-bio-7070-exec-7]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while
> executing SQL "select count(*) from optionaction 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.GeneratedMethodAccessor231.invoke(Unknown Source)
> 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:150)
> 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.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.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)
>
>
>
> model的json如下:
> { "uuid": "b3ab4b8f-a0ff-4447-aa2f-ef99601b4cb4", "last_modified":
> 1494400742455, "version": "1.6.0", "name": "optionaction", "owner":
> "ADMIN", "description": "", "fact_table": "DEFAULT.OPTIONACTION",
> "lookups": [], "dimensions": [ { "table":
> "DEFAULT.OPTIONACTION", "columns": [ "DAY_TIME",
> "ACTION_TIME" ] } ], "metrics": [ "TIMELONG" ],
> "filter_condition": "", "partition_desc": { "partition_date_column":
> null, "partition_time_column": null, "partition_date_start": 0,
> "partition_date_format": "yyyy-MM-dd", "partition_time_format":
> "HH:mm:ss", "partition_type": "APPEND",
> "partition_condition_builder": "org.apache.kylin.metadata.
> model.PartitionDesc$DefaultPartitionConditionBuilder" }, "capacity":
> "MEDIUM" }cube的json如下:{ "uuid": "1c2e6bde-5585-4c65-8acc-23a4c1c97327",
> "last_modified": 1494400779957, "version": "1.6.0", "name": "fff",
> "model_name": "optionaction", "description": "", "null_string": null,
> "dimensions": [ { "name": "ACTION_TIME", "table":
> "DEFAULT.OPTIONACTION", "column": "ACTION_TIME", "derived":
> null }, { "name": "DAY_TIME", "table":
> "DEFAULT.OPTIONACTION", "column": "DAY_TIME", "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": "DAY_TIME",
> "encoding": "dict", "isShardBy": false } ] },
> "hbase_mapping": { "column_family": [ { "name": "F1",
> "columns": [ { "qualifier": "M",
> "measure_refs": [ "_COUNT_" ] }
> ] } ] }, "aggregation_groups": [ { "includes": [
> "ACTION_TIME", "DAY_TIME" ], "select_rule": {
> "hierarchy_dims": [], "mandatory_dims": [
> "ACTION_TIME", "DAY_TIME" ], "joint_dims": []
> } } ], "signature": "WjZxEEgxvIj1rYHTKojHWg==", "notify_list":
> [], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED"
> ], "partition_date_start": 0, "partition_date_end": 3153600000000,
> "auto_merge_time_ranges": [ 604800000, 2419200000 ],
> "retention_range": 0, "engine_type": 2, "storage_type": 2,
> "override_kylin_properties": {} }
>
回复: java.sql.SQLException: Error while executing SQL "selectcount(*)from optionaction LIMIT 50000": null
Posted by 35925138 <35...@qq.com>.
多谢赐教,修改了这个属性以后,好用了。非常感谢
------------------ 原始邮件 ------------------
发件人: "Billy Liu";<bi...@apache.org>;
发送时间: 2017年5月11日(星期四) 中午1:21
收件人: "dev"<de...@kylin.apache.org>;
主题: Re: java.sql.SQLException: Error while executing SQL "selectcount(*)from optionaction LIMIT 50000": null
As the issue describes, if all dimensions are mandatory, it's not valid.
In your case, the only two dimensions are mandatory. Upgrade to the latest
2.0 will fix your issue.
2017-05-11 13:04 GMT+08:00 35925138 <35...@qq.com>:
> 但是我看这个问题不是在1.5.3版本解决了吗?为什么我的版本是1.6.0还有这个问题呢?而且问题的描述也不是我这个问题吧
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "Billy Liu";<bi...@apache.org>;
> 发送时间: 2017年5月10日(星期三) 下午5:40
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: Re: java.sql.SQLException: Error while executing SQL "select
> count(*)from optionaction LIMIT 50000": null
>
>
>
> You hit the issue https://issues.apache.org/jira/browse/KYLIN-1749
> It's not about how the filter defines, but the mandatory dimension chosen.
>
>
> 2017-05-10 15:50 GMT+08:00 35925138 <35...@qq.com>:
>
> > 能告诉我产生这个错误可能的原因也可以。
> >
> >
> >
> >
> > ------------------ 原始邮件 ------------------
> > 发件人: "35925138";<35...@qq.com>;
> > 发送时间: 2017年5月10日(星期三) 下午3:46
> > 收件人: "dev"<de...@kylin.apache.org>;
> >
> > 主题: java.sql.SQLException: Error while executing SQL "select count(*)
> > from optionaction LIMIT 50000": null
> >
> >
> >
> > 各位大牛: 各位大牛,这个问题我之前遇见过一次,因为我的model 里的 filter
> > 里,写了如下条件:userid!='',我把这个修改成了 userid<>''
> > 就解决了,但是现在,我重新建了一次optionaction表,这个问题又回来,不过这次我就算把filter清空了,仍然有这个问题出现,
> 我对表的操作一个是将原来的第一个字段的类型由string,
> > 修改成了int,另外将原来hbase 中的数据不存在的字段,给了一个默认的值'--',其他的就没有什么操作。每次执行与聚合相关的sql,
> > 都会报这么一个错误,我现在实在是不清楚为什么会报这样的错误,谁能给指点一下,
> > 日志如下:
> > 2017-05-10 15:30:51,275 ERROR [Query 7d8bc954-4fad-4cea-ad98-
> 46a248e28324-81]
> > service.QueryService:372 : Exception when execute sql
> > java.sql.SQLException: Error while executing SQL "select count(*) from
> > optionaction
> > LIMIT 50000": null
> > 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:147)
> > at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> > AvaticaStatement.java:208)
> > at org.apache.kylin.rest.service.QueryService.execute(
> > QueryService.java:538)
> > at org.apache.kylin.rest.service.QueryService.
> queryWithSqlMassage(
> > QueryService.java:452)
> > at org.apache.kylin.rest.service.QueryService.query(
> > QueryService.java:151)
> > at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> > QueryService.java:354)
> > at org.apache.kylin.rest.controller.QueryController.
> > query(QueryController.java:69)
> > at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown Source)
> > 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:150)
> > 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.
> > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> > er.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)
> > Caused by: java.util.NoSuchElementException
> > at java.util.ArrayList$Itr.next(ArrayList.java:854)
> > at java.util.Collections.min(Collections.java:635)
> > at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> > Cuboid.java:217)
> > at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> > Cuboid.java:141)
> > at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
> > at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.
> > java:68)
> > at org.apache.kylin.storage.gtrecord.
> > GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104)
> > at org.apache.kylin.query.enumerator.OLAPEnumerator.
> > queryStorage(OLAPEnumerator.java:114)
> > at org.apache.kylin.query.enumerator.OLAPEnumerator.
> > moveNext(OLAPEnumerator.java:65)
> > at Baz$1$1.moveNext(Unknown Source)
> > at org.apache.calcite.linq4j.EnumerableDefaults.aggregate(
> > EnumerableDefaults.java:116)
> > at org.apache.calcite.linq4j.DefaultEnumerable.aggregate(
> > DefaultEnumerable.java:107)
> > at Baz.bind(Unknown Source)
> > at org.apache.calcite.jdbc.CalcitePrepare$
> > CalciteSignature.enumerable(CalcitePrepare.java:327)
> > at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(
> > CalciteConnectionImpl.java:282)
> > at org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(
> > CalciteMetaImpl.java:553)
> > at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(
> > CalciteMetaImpl.java:544)
> > at org.apache.calcite.avatica.AvaticaResultSet.execute(
> > AvaticaResultSet.java:187)
> > 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:605)
> > at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(
> > CalciteMetaImpl.java:599)
> > at org.apache.calcite.avatica.AvaticaConnection.
> > prepareAndExecuteInternal(AvaticaConnection.java:613)
> > at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> > AvaticaStatement.java:139)
> > ... 76 more
> > 2017-05-10 15:30:51,276 INFO [Query 7d8bc954-4fad-4cea-ad98-
> 46a248e28324-81]
> > service.QueryService:284 :
> > ==========================[QUERY]===============================
> > Query Id: 7d8bc954-4fad-4cea-ad98-46a248e28324
> > SQL: select count(*) from optionaction
> > LIMIT 50000
> > User: ADMIN
> > Success: false
> > Duration: 0.0
> > Project: optionaction
> > Realization Names: [fff]
> > Cuboid Ids: []
> > 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 count(*) from optionaction
> > LIMIT 50000": null
> > ==========================[QUERY]===============================
> >
> >
> > 2017-05-10 15:30:51,276 ERROR [http-bio-7070-exec-7]
> > controller.BasicController:44 :
> > org.apache.kylin.rest.exception.InternalErrorException: Error while
> > executing SQL "select count(*) from optionaction 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.GeneratedMethodAccessor231.invoke(Unknown Source)
> > 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:150)
> > 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.
> > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> > er.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)
> >
> >
> >
> > model的json如下:
> > { "uuid": "b3ab4b8f-a0ff-4447-aa2f-ef99601b4cb4", "last_modified":
> > 1494400742455, "version": "1.6.0", "name": "optionaction", "owner":
> > "ADMIN", "description": "", "fact_table": "DEFAULT.OPTIONACTION",
> > "lookups": [], "dimensions": [ { "table":
> > "DEFAULT.OPTIONACTION", "columns": [ "DAY_TIME",
> > "ACTION_TIME" ] } ], "metrics": [ "TIMELONG" ],
> > "filter_condition": "", "partition_desc": {
> "partition_date_column":
> > null, "partition_time_column": null, "partition_date_start": 0,
> > "partition_date_format": "yyyy-MM-dd", "partition_time_format":
> > "HH:mm:ss", "partition_type": "APPEND",
> > "partition_condition_builder": "org.apache.kylin.metadata.
> > model.PartitionDesc$DefaultPartitionConditionBuilder" }, "capacity":
> > "MEDIUM" }cube的json如下:{ "uuid": "1c2e6bde-5585-4c65-8acc-
> 23a4c1c97327",
> > "last_modified": 1494400779957, "version": "1.6.0", "name": "fff",
> > "model_name": "optionaction", "description": "", "null_string":
> null,
> > "dimensions": [ { "name": "ACTION_TIME", "table":
> > "DEFAULT.OPTIONACTION", "column": "ACTION_TIME", "derived":
> > null }, { "name": "DAY_TIME", "table":
> > "DEFAULT.OPTIONACTION", "column": "DAY_TIME", "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": "DAY_TIME",
> > "encoding": "dict", "isShardBy": false } ] },
> > "hbase_mapping": { "column_family": [ { "name": "F1",
> > "columns": [ { "qualifier": "M",
> > "measure_refs": [ "_COUNT_" ] }
> > ] } ] }, "aggregation_groups": [ { "includes": [
> > "ACTION_TIME", "DAY_TIME" ], "select_rule": {
> > "hierarchy_dims": [], "mandatory_dims": [
> > "ACTION_TIME", "DAY_TIME" ], "joint_dims": []
> > } } ], "signature": "WjZxEEgxvIj1rYHTKojHWg==",
> "notify_list":
> > [], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED"
> > ], "partition_date_start": 0, "partition_date_end": 3153600000000,
> > "auto_merge_time_ranges": [ 604800000, 2419200000 ],
> > "retention_range": 0, "engine_type": 2, "storage_type": 2,
> > "override_kylin_properties": {} }
> >
>
Re: java.sql.SQLException: Error while executing SQL "select
count(*)from optionaction LIMIT 50000": null
Posted by Billy Liu <bi...@apache.org>.
As the issue describes, if all dimensions are mandatory, it's not valid.
In your case, the only two dimensions are mandatory. Upgrade to the latest
2.0 will fix your issue.
2017-05-11 13:04 GMT+08:00 35925138 <35...@qq.com>:
> 但是我看这个问题不是在1.5.3版本解决了吗?为什么我的版本是1.6.0还有这个问题呢?而且问题的描述也不是我这个问题吧
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "Billy Liu";<bi...@apache.org>;
> 发送时间: 2017年5月10日(星期三) 下午5:40
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: Re: java.sql.SQLException: Error while executing SQL "select
> count(*)from optionaction LIMIT 50000": null
>
>
>
> You hit the issue https://issues.apache.org/jira/browse/KYLIN-1749
> It's not about how the filter defines, but the mandatory dimension chosen.
>
>
> 2017-05-10 15:50 GMT+08:00 35925138 <35...@qq.com>:
>
> > 能告诉我产生这个错误可能的原因也可以。
> >
> >
> >
> >
> > ------------------ 原始邮件 ------------------
> > 发件人: "35925138";<35...@qq.com>;
> > 发送时间: 2017年5月10日(星期三) 下午3:46
> > 收件人: "dev"<de...@kylin.apache.org>;
> >
> > 主题: java.sql.SQLException: Error while executing SQL "select count(*)
> > from optionaction LIMIT 50000": null
> >
> >
> >
> > 各位大牛: 各位大牛,这个问题我之前遇见过一次,因为我的model 里的 filter
> > 里,写了如下条件:userid!='',我把这个修改成了 userid<>''
> > 就解决了,但是现在,我重新建了一次optionaction表,这个问题又回来,不过这次我就算把filter清空了,仍然有这个问题出现,
> 我对表的操作一个是将原来的第一个字段的类型由string,
> > 修改成了int,另外将原来hbase 中的数据不存在的字段,给了一个默认的值'--',其他的就没有什么操作。每次执行与聚合相关的sql,
> > 都会报这么一个错误,我现在实在是不清楚为什么会报这样的错误,谁能给指点一下,
> > 日志如下:
> > 2017-05-10 15:30:51,275 ERROR [Query 7d8bc954-4fad-4cea-ad98-
> 46a248e28324-81]
> > service.QueryService:372 : Exception when execute sql
> > java.sql.SQLException: Error while executing SQL "select count(*) from
> > optionaction
> > LIMIT 50000": null
> > 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:147)
> > at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> > AvaticaStatement.java:208)
> > at org.apache.kylin.rest.service.QueryService.execute(
> > QueryService.java:538)
> > at org.apache.kylin.rest.service.QueryService.
> queryWithSqlMassage(
> > QueryService.java:452)
> > at org.apache.kylin.rest.service.QueryService.query(
> > QueryService.java:151)
> > at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> > QueryService.java:354)
> > at org.apache.kylin.rest.controller.QueryController.
> > query(QueryController.java:69)
> > at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown Source)
> > 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:150)
> > 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.
> > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> > er.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)
> > Caused by: java.util.NoSuchElementException
> > at java.util.ArrayList$Itr.next(ArrayList.java:854)
> > at java.util.Collections.min(Collections.java:635)
> > at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> > Cuboid.java:217)
> > at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> > Cuboid.java:141)
> > at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
> > at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.
> > java:68)
> > at org.apache.kylin.storage.gtrecord.
> > GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104)
> > at org.apache.kylin.query.enumerator.OLAPEnumerator.
> > queryStorage(OLAPEnumerator.java:114)
> > at org.apache.kylin.query.enumerator.OLAPEnumerator.
> > moveNext(OLAPEnumerator.java:65)
> > at Baz$1$1.moveNext(Unknown Source)
> > at org.apache.calcite.linq4j.EnumerableDefaults.aggregate(
> > EnumerableDefaults.java:116)
> > at org.apache.calcite.linq4j.DefaultEnumerable.aggregate(
> > DefaultEnumerable.java:107)
> > at Baz.bind(Unknown Source)
> > at org.apache.calcite.jdbc.CalcitePrepare$
> > CalciteSignature.enumerable(CalcitePrepare.java:327)
> > at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(
> > CalciteConnectionImpl.java:282)
> > at org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(
> > CalciteMetaImpl.java:553)
> > at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(
> > CalciteMetaImpl.java:544)
> > at org.apache.calcite.avatica.AvaticaResultSet.execute(
> > AvaticaResultSet.java:187)
> > 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:605)
> > at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(
> > CalciteMetaImpl.java:599)
> > at org.apache.calcite.avatica.AvaticaConnection.
> > prepareAndExecuteInternal(AvaticaConnection.java:613)
> > at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> > AvaticaStatement.java:139)
> > ... 76 more
> > 2017-05-10 15:30:51,276 INFO [Query 7d8bc954-4fad-4cea-ad98-
> 46a248e28324-81]
> > service.QueryService:284 :
> > ==========================[QUERY]===============================
> > Query Id: 7d8bc954-4fad-4cea-ad98-46a248e28324
> > SQL: select count(*) from optionaction
> > LIMIT 50000
> > User: ADMIN
> > Success: false
> > Duration: 0.0
> > Project: optionaction
> > Realization Names: [fff]
> > Cuboid Ids: []
> > 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 count(*) from optionaction
> > LIMIT 50000": null
> > ==========================[QUERY]===============================
> >
> >
> > 2017-05-10 15:30:51,276 ERROR [http-bio-7070-exec-7]
> > controller.BasicController:44 :
> > org.apache.kylin.rest.exception.InternalErrorException: Error while
> > executing SQL "select count(*) from optionaction 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.GeneratedMethodAccessor231.invoke(Unknown Source)
> > 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:150)
> > 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.
> > SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> > er.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)
> >
> >
> >
> > model的json如下:
> > { "uuid": "b3ab4b8f-a0ff-4447-aa2f-ef99601b4cb4", "last_modified":
> > 1494400742455, "version": "1.6.0", "name": "optionaction", "owner":
> > "ADMIN", "description": "", "fact_table": "DEFAULT.OPTIONACTION",
> > "lookups": [], "dimensions": [ { "table":
> > "DEFAULT.OPTIONACTION", "columns": [ "DAY_TIME",
> > "ACTION_TIME" ] } ], "metrics": [ "TIMELONG" ],
> > "filter_condition": "", "partition_desc": {
> "partition_date_column":
> > null, "partition_time_column": null, "partition_date_start": 0,
> > "partition_date_format": "yyyy-MM-dd", "partition_time_format":
> > "HH:mm:ss", "partition_type": "APPEND",
> > "partition_condition_builder": "org.apache.kylin.metadata.
> > model.PartitionDesc$DefaultPartitionConditionBuilder" }, "capacity":
> > "MEDIUM" }cube的json如下:{ "uuid": "1c2e6bde-5585-4c65-8acc-
> 23a4c1c97327",
> > "last_modified": 1494400779957, "version": "1.6.0", "name": "fff",
> > "model_name": "optionaction", "description": "", "null_string":
> null,
> > "dimensions": [ { "name": "ACTION_TIME", "table":
> > "DEFAULT.OPTIONACTION", "column": "ACTION_TIME", "derived":
> > null }, { "name": "DAY_TIME", "table":
> > "DEFAULT.OPTIONACTION", "column": "DAY_TIME", "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": "DAY_TIME",
> > "encoding": "dict", "isShardBy": false } ] },
> > "hbase_mapping": { "column_family": [ { "name": "F1",
> > "columns": [ { "qualifier": "M",
> > "measure_refs": [ "_COUNT_" ] }
> > ] } ] }, "aggregation_groups": [ { "includes": [
> > "ACTION_TIME", "DAY_TIME" ], "select_rule": {
> > "hierarchy_dims": [], "mandatory_dims": [
> > "ACTION_TIME", "DAY_TIME" ], "joint_dims": []
> > } } ], "signature": "WjZxEEgxvIj1rYHTKojHWg==",
> "notify_list":
> > [], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED"
> > ], "partition_date_start": 0, "partition_date_end": 3153600000000,
> > "auto_merge_time_ranges": [ 604800000, 2419200000 ],
> > "retention_range": 0, "engine_type": 2, "storage_type": 2,
> > "override_kylin_properties": {} }
> >
>
回复: java.sql.SQLException: Error while executing SQL "select count(*)from optionaction LIMIT 50000": null
Posted by 35925138 <35...@qq.com>.
但是我看这个问题不是在1.5.3版本解决了吗?为什么我的版本是1.6.0还有这个问题呢?而且问题的描述也不是我这个问题吧
------------------ 原始邮件 ------------------
发件人: "Billy Liu";<bi...@apache.org>;
发送时间: 2017年5月10日(星期三) 下午5:40
收件人: "dev"<de...@kylin.apache.org>;
主题: Re: java.sql.SQLException: Error while executing SQL "select count(*)from optionaction LIMIT 50000": null
You hit the issue https://issues.apache.org/jira/browse/KYLIN-1749
It's not about how the filter defines, but the mandatory dimension chosen.
2017-05-10 15:50 GMT+08:00 35925138 <35...@qq.com>:
> 能告诉我产生这个错误可能的原因也可以。
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "35925138";<35...@qq.com>;
> 发送时间: 2017年5月10日(星期三) 下午3:46
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: java.sql.SQLException: Error while executing SQL "select count(*)
> from optionaction LIMIT 50000": null
>
>
>
> 各位大牛: 各位大牛,这个问题我之前遇见过一次,因为我的model 里的 filter
> 里,写了如下条件:userid!='',我把这个修改成了 userid<>''
> 就解决了,但是现在,我重新建了一次optionaction表,这个问题又回来,不过这次我就算把filter清空了,仍然有这个问题出现,我对表的操作一个是将原来的第一个字段的类型由string,
> 修改成了int,另外将原来hbase 中的数据不存在的字段,给了一个默认的值'--',其他的就没有什么操作。每次执行与聚合相关的sql,
> 都会报这么一个错误,我现在实在是不清楚为什么会报这样的错误,谁能给指点一下,
> 日志如下:
> 2017-05-10 15:30:51,275 ERROR [Query 7d8bc954-4fad-4cea-ad98-46a248e28324-81]
> service.QueryService:372 : Exception when execute sql
> java.sql.SQLException: Error while executing SQL "select count(*) from
> optionaction
> LIMIT 50000": null
> 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:147)
> at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> AvaticaStatement.java:208)
> at org.apache.kylin.rest.service.QueryService.execute(
> QueryService.java:538)
> at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(
> QueryService.java:452)
> at org.apache.kylin.rest.service.QueryService.query(
> QueryService.java:151)
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:354)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> at sun.reflect.GeneratedMethodAccessor231.invoke(Unknown Source)
> 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:150)
> 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.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.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)
> Caused by: java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:854)
> at java.util.Collections.min(Collections.java:635)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:217)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:141)
> at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
> at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.
> java:68)
> at org.apache.kylin.storage.gtrecord.
> GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> queryStorage(OLAPEnumerator.java:114)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> moveNext(OLAPEnumerator.java:65)
> at Baz$1$1.moveNext(Unknown Source)
> at org.apache.calcite.linq4j.EnumerableDefaults.aggregate(
> EnumerableDefaults.java:116)
> at org.apache.calcite.linq4j.DefaultEnumerable.aggregate(
> DefaultEnumerable.java:107)
> at Baz.bind(Unknown Source)
> at org.apache.calcite.jdbc.CalcitePrepare$
> CalciteSignature.enumerable(CalcitePrepare.java:327)
> at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(
> CalciteConnectionImpl.java:282)
> at org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(
> CalciteMetaImpl.java:553)
> at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(
> CalciteMetaImpl.java:544)
> at org.apache.calcite.avatica.AvaticaResultSet.execute(
> AvaticaResultSet.java:187)
> 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:605)
> at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(
> CalciteMetaImpl.java:599)
> at org.apache.calcite.avatica.AvaticaConnection.
> prepareAndExecuteInternal(AvaticaConnection.java:613)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:139)
> ... 76 more
> 2017-05-10 15:30:51,276 INFO [Query 7d8bc954-4fad-4cea-ad98-46a248e28324-81]
> service.QueryService:284 :
> ==========================[QUERY]===============================
> Query Id: 7d8bc954-4fad-4cea-ad98-46a248e28324
> SQL: select count(*) from optionaction
> LIMIT 50000
> User: ADMIN
> Success: false
> Duration: 0.0
> Project: optionaction
> Realization Names: [fff]
> Cuboid Ids: []
> 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 count(*) from optionaction
> LIMIT 50000": null
> ==========================[QUERY]===============================
>
>
> 2017-05-10 15:30:51,276 ERROR [http-bio-7070-exec-7]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while
> executing SQL "select count(*) from optionaction 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.GeneratedMethodAccessor231.invoke(Unknown Source)
> 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:150)
> 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.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.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)
>
>
>
> model的json如下:
> { "uuid": "b3ab4b8f-a0ff-4447-aa2f-ef99601b4cb4", "last_modified":
> 1494400742455, "version": "1.6.0", "name": "optionaction", "owner":
> "ADMIN", "description": "", "fact_table": "DEFAULT.OPTIONACTION",
> "lookups": [], "dimensions": [ { "table":
> "DEFAULT.OPTIONACTION", "columns": [ "DAY_TIME",
> "ACTION_TIME" ] } ], "metrics": [ "TIMELONG" ],
> "filter_condition": "", "partition_desc": { "partition_date_column":
> null, "partition_time_column": null, "partition_date_start": 0,
> "partition_date_format": "yyyy-MM-dd", "partition_time_format":
> "HH:mm:ss", "partition_type": "APPEND",
> "partition_condition_builder": "org.apache.kylin.metadata.
> model.PartitionDesc$DefaultPartitionConditionBuilder" }, "capacity":
> "MEDIUM" }cube的json如下:{ "uuid": "1c2e6bde-5585-4c65-8acc-23a4c1c97327",
> "last_modified": 1494400779957, "version": "1.6.0", "name": "fff",
> "model_name": "optionaction", "description": "", "null_string": null,
> "dimensions": [ { "name": "ACTION_TIME", "table":
> "DEFAULT.OPTIONACTION", "column": "ACTION_TIME", "derived":
> null }, { "name": "DAY_TIME", "table":
> "DEFAULT.OPTIONACTION", "column": "DAY_TIME", "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": "DAY_TIME",
> "encoding": "dict", "isShardBy": false } ] },
> "hbase_mapping": { "column_family": [ { "name": "F1",
> "columns": [ { "qualifier": "M",
> "measure_refs": [ "_COUNT_" ] }
> ] } ] }, "aggregation_groups": [ { "includes": [
> "ACTION_TIME", "DAY_TIME" ], "select_rule": {
> "hierarchy_dims": [], "mandatory_dims": [
> "ACTION_TIME", "DAY_TIME" ], "joint_dims": []
> } } ], "signature": "WjZxEEgxvIj1rYHTKojHWg==", "notify_list":
> [], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED"
> ], "partition_date_start": 0, "partition_date_end": 3153600000000,
> "auto_merge_time_ranges": [ 604800000, 2419200000 ],
> "retention_range": 0, "engine_type": 2, "storage_type": 2,
> "override_kylin_properties": {} }
>