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 <35925...@qq.com>: > 但是我看这个问题不是在1.5.3版本解决了吗？为什么我的版本是1.6.0还有这个问题呢？而且问题的描述也不是我这个问题吧 > > > > > ------------------ 原始邮件 ------------------ > 发件人: "Billy Liu";<billy...@apache.org>; > 发送时间: 2017年5月10日(星期三) 下午5:40 > 收件人: "dev"<dev@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 <35925...@qq.com>: > > > 能告诉我产生这个错误可能的原因也可以。 > > > > > > > > > > ------------------ 原始邮件 ------------------ > > 发件人: "35925138";<35925...@qq.com>; > > 发送时间: 2017年5月10日(星期三) 下午3:46 > > 收件人: "dev"<dev@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": {} } > > >
