Thx, I will try to reproduce this error ASAP
> 在 2019年10月28日，13:45，Wang rupeng <[email protected]> 写道：
>
> Hi,
> I followed your steps and I got the same error too. But I find that if I
> add “KYLIN_SALES.LSTG_FORMAT_NAME” in kylin_sales_model’s measures step.
> Then your sql that contains “count(KYLIN_SALES.LSTG_FORMAT_NAME) as
> COUNT_LF”will be fine. So get back to your origin problem, you may check if
> your
> model need to add the count columns to ‘Measures’.
>
> <image001.png>
> <image002.png>
>
>
> 发件人: 奥威软件 <[email protected] <mailto:[email protected]>>
> 答复: <[email protected] <mailto:[email protected]>>
> 日期: 2019年10月26日 星期六 17:43
> 收件人: kylin_user <[email protected]>
> 主题: strange error! java.lang.IndexOutOfBoundsException: Index: 43, Size: 43
> appear in double select sql query
>
> hi
>
> strange error! java.lang.IndexOutOfBoundsException: Index: 43, Size: 43
> appear in double select sql query
>
> error arise when i use count as " count(RESOURCE_DIM."RENTED") as "已出租数量"
> ",
>
> but when i change to " sum(RESOURCE_DIM.RESOURCEAREA ) as "sum" " sql work
> fine~!
>
> it looks like i cann't use count in sql;
>
> blew is error info:
>
> 2019-10-26 09:22:19,993 INFO [FetcherRunner 314482988-53]
> threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 actual
> running, 1 stopped, 0 ready, 8 already succeed, 0 error, 0 discarded, 0 others
>
> 2019-10-26 09:22:29,024 INFO [http-nio-7070-exec-1] service.QueryService:374
> : Check query permission in 0 ms.
>
> 2019-10-26 09:22:29,025 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> service.QueryService:411 : Using project: huaQTest
>
> 2019-10-26 09:22:29,025 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> service.QueryService:412 : The original query: select
>
> "FLOOR" as "楼层" ,
>
> "CUSTYPENAME" as "铺位类别"
>
> ,count(RESOURCE_DIM."RENTED") as "已出租数量"
>
> from
>
> RESOURCE_DIM
>
> join LEVELDIMENSION_DIM on
>
> RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
>
> join RESOURCETYPE_DIM on
>
> RESOURCE_DIM.RESOURCETYPE_SK = RESOURCETYPE_DIM.RESOURCETYPE_SK
>
> join RESOURCESTATUS_DIM on
>
> RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK
>
> join (
>
> select * from T_RIGHT_POWERBI_ROLE
>
> as T1
>
> where
>
> T1.FTABLEID = 'HQMART_DW.LEVELDIMENSION_DIM'
>
> and T1.FROLEID = 'role2a9fb1505b2f11e9a4f079bdc111c187'
>
> and T1.FDSVID = 'resource_model_20190828'
>
> )
>
> as F1
>
> on F1.FDIMID = LEVELDIMENSION_DIM.COMPANYNAME
>
> where
>
> ( RESOURCE_DIM.DATETIME between '2019-01-01 00:00:00' and '2019-12-31
> 00:00:00' )
>
> and "RESOURCESTATUSNAME" in ('未出租',
>
> '已出租',
>
> '已预留')
>
> and "RESOURCETYPENAME" = '铺位'
>
> group by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
>
>
> order by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
> 2019-10-26 09:22:29,038 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> service.QueryService:627 : The corrected query: select
>
> "FLOOR" as "楼层" ,
>
> "CUSTYPENAME" as "铺位类别"
>
> ,count(RESOURCE_DIM."RENTED") as "已出租数量"
>
> from
>
> RESOURCE_DIM
>
> join LEVELDIMENSION_DIM on
>
> RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
>
> join RESOURCETYPE_DIM on
>
> RESOURCE_DIM.RESOURCETYPE_SK = RESOURCETYPE_DIM.RESOURCETYPE_SK
>
> join RESOURCESTATUS_DIM on
>
> RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK
>
> join (
>
> select * from T_RIGHT_POWERBI_ROLE
>
> as T1
>
> where
>
> T1.FTABLEID = 'HQMART_DW.LEVELDIMENSION_DIM'
>
> and T1.FROLEID = 'role2a9fb1505b2f11e9a4f079bdc111c187'
>
> and T1.FDSVID = 'resource_model_20190828'
>
> )
>
> as F1
>
> on F1.FDIMID = LEVELDIMENSION_DIM.COMPANYNAME
>
> where
>
> ( RESOURCE_DIM.DATETIME between '2019-01-01 00:00:00' and '2019-12-31
> 00:00:00' )
>
> and "RESOURCESTATUSNAME" in ('未出租',
>
> '已出租',
>
> '已预留')
>
> and "RESOURCETYPENAME" = '铺位'
>
> group by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
>
>
> order by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
> LIMIT 50000
>
> 2019-10-26 09:22:29,166 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:58 : Find candidates by table DEFAULT.RESOURCE_DIM and
> project=huaQTest : CUBE[name=hq_cube_test_clone_notime]
>
> 2019-10-26 09:22:29,167 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:51 : Applying rule: class
> org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
> realizations before: [CUBE[name=hq_cube_test_clone_notime]], realizations
> after: [CUBE[name=hq_cube_test_clone_notime]]
>
> 2019-10-26 09:22:29,167 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:51 : Applying rule: class
> org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
> realizations before: [CUBE[name=hq_cube_test_clone_notime]], realizations
> after: [CUBE[name=hq_cube_test_clone_notime]]
>
> 2019-10-26 09:22:29,167 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> rules.RealizationSortRule:40 : CUBE[name=hq_cube_test_clone_notime] priority
> 1 cost 589.
>
> 2019-10-26 09:22:29,167 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:51 : Applying rule: class
> org.apache.kylin.query.routing.rules.RealizationSortRule, realizations
> before: [CUBE[name=hq_cube_test_clone_notime]], realizations after:
> [CUBE[name=hq_cube_test_clone_notime]]
>
> 2019-10-26 09:22:29,168 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:75 : The realizations remaining:
> [CUBE[name=hq_cube_test_clone_notime]],and the final chosen one for current
> olap context 0 is CUBE[name=hq_cube_test_clone_notime]
>
> 2019-10-26 09:22:29,168 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:58 : Find candidates by table
> DEFAULT.T_RIGHT_POWERBI_ROLE and project=huaQTest :
> CUBE[name=t_right_powerbi_role_cube]
>
> 2019-10-26 09:22:29,168 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:51 : Applying rule: class
> org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
> realizations before: [CUBE[name=t_right_powerbi_role_cube]], realizations
> after: [CUBE[name=t_right_powerbi_role_cube]]
>
> 2019-10-26 09:22:29,169 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:51 : Applying rule: class
> org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
> realizations before: [CUBE[name=t_right_powerbi_role_cube]], realizations
> after: [CUBE[name=t_right_powerbi_role_cube]]
>
> 2019-10-26 09:22:29,169 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> rules.RealizationSortRule:40 : CUBE[name=t_right_powerbi_role_cube] priority
> 1 cost 11100.
>
> 2019-10-26 09:22:29,169 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:51 : Applying rule: class
> org.apache.kylin.query.routing.rules.RealizationSortRule, realizations
> before: [CUBE[name=t_right_powerbi_role_cube]], realizations after:
> [CUBE[name=t_right_powerbi_role_cube]]
>
> 2019-10-26 09:22:29,169 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> routing.QueryRouter:75 : The realizations remaining:
> [CUBE[name=t_right_powerbi_role_cube]],and the final chosen one for current
> olap context 1 is CUBE[name=t_right_powerbi_role_cube]
>
> 2019-10-26 09:22:29,171 ERROR [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> service.QueryService:518 : Exception while executing query
>
> java.sql.SQLException: Error while executing SQL "select
>
> "FLOOR" as "楼层" ,
>
> "CUSTYPENAME" as "铺位类别"
>
> ,count(RESOURCE_DIM."RENTED") as "已出租数量"
>
> from
>
> RESOURCE_DIM
>
> join LEVELDIMENSION_DIM on
>
> RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
>
> join RESOURCETYPE_DIM on
>
> RESOURCE_DIM.RESOURCETYPE_SK = RESOURCETYPE_DIM.RESOURCETYPE_SK
>
> join RESOURCESTATUS_DIM on
>
> RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK
>
> join (
>
> select * from T_RIGHT_POWERBI_ROLE
>
> as T1
>
> where
>
> T1.FTABLEID = 'HQMART_DW.LEVELDIMENSION_DIM'
>
> and T1.FROLEID = 'role2a9fb1505b2f11e9a4f079bdc111c187'
>
> and T1.FDSVID = 'resource_model_20190828'
>
> )
>
> as F1
>
> on F1.FDIMID = LEVELDIMENSION_DIM.COMPANYNAME
>
> where
>
> ( RESOURCE_DIM.DATETIME between '2019-01-01 00:00:00' and '2019-12-31
> 00:00:00' )
>
> and "RESOURCESTATUSNAME" in ('未出租',
>
> '已出租',
>
> '已预留')
>
> and "RESOURCETYPENAME" = '铺位'
>
> group by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
>
>
> order by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
> LIMIT 50000": Index: 43, Size: 43
>
> 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:156)
>
> at
> org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:218)
>
> at
> org.apache.kylin.rest.service.QueryService.executeRequest(QueryService.java:946)
>
> at
> org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:649)
>
> at org.apache.kylin.rest.service.QueryService.query(QueryService.java:216)
>
> at
> org.apache.kylin.rest.service.QueryService.queryAndUpdateCache(QueryService.java:476)
>
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:437)
>
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:375)
>
> at
> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:498)
>
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
>
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
>
> at
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
>
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
>
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
>
> at
> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
>
> at
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
>
> at
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
>
> at
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
>
> at
> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
>
> at
> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
>
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
>
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
>
> at
> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
>
> at
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
>
> at
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> 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:193)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
>
> at
> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
>
> at
> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
>
> at
> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>
> at
> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
>
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
>
> at
> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>
> at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>
> at java.lang.Thread.run(Thread.java:748)
>
> Caused by: java.lang.IndexOutOfBoundsException: Index: 43, Size: 43
>
> at java.util.ArrayList.rangeCheck(ArrayList.java:657)
>
> at java.util.ArrayList.get(ArrayList.java:433)
>
> at
> org.apache.calcite.rex.RexProgramBuilder$RegisterInputShuttle.visitInputRef(RexProgramBuilder.java:956)
>
> at
> org.apache.calcite.rex.RexProgramBuilder$RegisterInputShuttle.visitInputRef(RexProgramBuilder.java:927)
>
> at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:112)
>
> at
> org.apache.calcite.rex.RexProgramBuilder.registerInput(RexProgramBuilder.java:297)
>
> at
> org.apache.calcite.rex.RexProgramBuilder.addProject(RexProgramBuilder.java:208)
>
> at org.apache.calcite.rex.RexProgram.create(RexProgram.java:220)
>
> at org.apache.calcite.rex.RexProgram.create(RexProgram.java:189)
>
> at
> org.apache.kylin.query.relnode.OLAPProjectRel.implementEnumerable(OLAPProjectRel.java:207)
>
> at
> org.apache.kylin.query.relnode.OLAPRel$JavaImplementor.createEnumerable(OLAPRel.java:225)
>
> at
> org.apache.kylin.query.relnode.OLAPRel$JavaImplementor.createEnumerable(OLAPRel.java:221)
>
> at
> org.apache.kylin.query.relnode.OLAPRel$JavaImplementor.createEnumerable(OLAPRel.java:221)
>
> at
> org.apache.kylin.query.relnode.OLAPRel$JavaImplementor.createEnumerable(OLAPRel.java:221)
>
> at
> org.apache.kylin.query.relnode.OLAPToEnumerableConverter.implement(OLAPToEnumerableConverter.java:104)
>
> at
> org.apache.calcite.adapter.enumerable.EnumerableRelImplementor.implementRoot(EnumerableRelImplementor.java:103)
>
> at
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:92)
>
> at
> org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1278)
>
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:331)
>
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:230)
>
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:796)
>
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:655)
>
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:618)
>
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:221)
>
> at
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:603)
>
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:638)
>
> at
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:149)
>
> ... 86 more
>
> 2019-10-26 09:22:29,173 WARN [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> common.QueryContext:196 : Cannot find CubeSegmentStatisticsResult for context > 0
>
> 2019-10-26 09:22:29,173 WARN [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> common.QueryContext:196 : Cannot find CubeSegmentStatisticsResult for context
> 1
>
> 2019-10-26 09:22:29,173 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> service.QueryService:1129 : Processed rows for each storageContext: 0 0
>
> 2019-10-26 09:22:29,174 INFO [Query 485245b9-a9b7-89a4-076d-c0261c79898e-57]
> service.QueryService:361 :
>
> ==========================[QUERY]===============================
>
> Query Id: 485245b9-a9b7-89a4-076d-c0261c79898e
>
> SQL: select
>
> "FLOOR" as "楼层" ,
>
> "CUSTYPENAME" as "铺位类别"
>
> ,count(RESOURCE_DIM."RENTED") as "已出租数量"
>
> from
>
> RESOURCE_DIM
>
> join LEVELDIMENSION_DIM on
>
> RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
>
> join RESOURCETYPE_DIM on
>
> RESOURCE_DIM.RESOURCETYPE_SK = RESOURCETYPE_DIM.RESOURCETYPE_SK
>
> join RESOURCESTATUS_DIM on
>
> RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK
>
> join (
>
> select * from T_RIGHT_POWERBI_ROLE
>
> as T1
>
> where
>
> T1.FTABLEID = 'HQMART_DW.LEVELDIMENSION_DIM'
>
> and T1.FROLEID = 'role2a9fb1505b2f11e9a4f079bdc111c187'
>
> and T1.FDSVID = 'resource_model_20190828'
>
> )
>
> as F1
>
> on F1.FDIMID = LEVELDIMENSION_DIM.COMPANYNAME
>
> where
>
> ( RESOURCE_DIM.DATETIME between '2019-01-01 00:00:00' and '2019-12-31
> 00:00:00' )
>
> and "RESOURCESTATUSNAME" in ('未出租',
>
> '已出租',
>
> '已预留')
>
> and "RESOURCETYPENAME" = '铺位'
>
> group by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
>
>
> order by
>
> "FLOOR",
>
> "CUSTYPENAME"
>
> User: ADMIN
>
> Success: false
>
> Duration: 0.149
>
> Project: huaQTest
>
> Realization Names: [CUBE[name=hq_cube_test_clone_notime],
> CUBE[name=t_right_powerbi_role_cube]]
>
> Cuboid Ids: []
>
> Total scan count: 0
>
> Total scan bytes: 0
>
> Result row count: 0
>
> Accept Partial: true
>
> Is Partial Result: false
>
> Hit Exception Cache: false
>
> Storage cache used: false
>
> Is Query Push-Down: false
>
> Is Prepare: false
>
> Trace URL: null
>
> Message: Index: 43, Size: 43
>
> while executing SQL: "select "FLOOR" as "楼层" , "CUSTYPENAME" as "铺位类别"
> ,count(RESOURCE_DIM."RENTED") as "已出租数量" from RESOURCE_DIM join
> LEVELDIMENSION_DIM on RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
> join RESOURCETYPE_DIM on RESOURCE_DIM.RESOURCETYPE_SK =
> RESOURCETYPE_DIM.RESOURCETYPE_SK join RESOURCESTATUS_DIM on
> RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK join (
> select * from T_RIGHT_POWERBI_ROLE as T1 where T1.FTABLEID =
> 'HQMART_DW.LEVELDIMENSION_DIM' and T1.FROLEID =
> 'role2a9fb1505b2f11e9a4f079bdc111c187' and T1.FDSVID =
> 'resource_model_20190828' ) as F1 on F1.FDIMID =
> LEVELDIMENSION_DIM.COMPANYNAME where ( RESOURCE_DIM.DATETIME between
> '2019-01-01 00:00:00' and '2019-12-31 00:00:00' ) and "RESOURCESTATUSNAME"
> in ('未出租', '已出租', '已预留') and "RESOURCETYPENAME" = '铺位' group by "FLOOR",
> "CUSTYPENAME" order by "FLOOR", "CUSTYPENAME" LIMIT 50000"
>
> ==========================[QUERY]===============================
>
>
>
> 2019-10-26 09:22:29,174 ERROR [http-nio-7070-exec-1]
> controller.BasicController:63 :
>
> org.apache.kylin.rest.exception.InternalErrorException: Index: 43, Size: 43
>
> while executing SQL: "select "FLOOR" as "楼层" , "CUSTYPENAME" as "铺位类别"
> ,count(RESOURCE_DIM."RENTED") as "已出租数量" from RESOURCE_DIM join
> LEVELDIMENSION_DIM on RESOURCE_DIM.LEVEL_SK = LEVELDIMENSION_DIM.LEVEL_SK
> join RESOURCETYPE_DIM on RESOURCE_DIM.RESOURCETYPE_SK =
> RESOURCETYPE_DIM.RESOURCETYPE_SK join RESOURCESTATUS_DIM on
> RESOURCE_DIM.RESOURCESTATUS_SK = RESOURCESTATUS_DIM.RESOURCESTATUS_SK join (
> select * from T_RIGHT_POWERBI_ROLE as T1 where T1.FTABLEID =
> 'HQMART_DW.LEVELDIMENSION_DIM' and T1.FROLEID =
> 'role2a9fb1505b2f11e9a4f079bdc111c187' and T1.FDSVID =
> 'resource_model_20190828' ) as F1 on F1.FDIMID =
> LEVELDIMENSION_DIM.COMPANYNAME where ( RESOURCE_DIM.DATETIME between
> '2019-01-01 00:00:00' and '2019-12-31 00:00:00' ) and "RESOURCESTATUSNAME"
> in ('未出租', '已出租', '已预留') and "RESOURCETYPENAME" = '铺位' group by "FLOOR",
> "CUSTYPENAME" order by "FLOOR", "CUSTYPENAME" LIMIT 50000"
>
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:449)
>
> at
> org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:375)
>
> at
> org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:498)
>
> at
> org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
>
> at
> org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
>
> at
> org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
>
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
>
> at
> org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
>
> at
> org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
>
> at
> org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
>
> at
> org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
>
> at
> org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
>
> at
> org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
>
> at
> org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
>
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
>
> at
> org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
>
> at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
>
> at
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
>
> at
> org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
>
> at
> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
>
> at
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
>
> at
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> 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:193)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
>
> at
> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
>
> at
> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
>
> at
> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
>
> at
> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
>
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
>
> at
> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
>
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>
> at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>
> at java.lang.Thread.run(Thread.java:748)
>
> 2019-10-26 09:22:47,166 INFO [BadQueryDetector] service.BadQueryDetector:147
> : Detect bad query.
>
> 2019-10-26 09:22:49,993 INFO [FetcherRunner 314482988-53]
> threadpool.DefaultFetcherRunner:85 : Job Fetcher: 0 should running, 0 actual
> running, 1 stopped, 0 ready, 8 already succeed, 0 error, 0 discarded, 0 others
>
