Hi, which version do you use and can you use the cube generated by sample.sh to reproduce this problem so that we can troubleshoot it?
> 在 2019年10月26日，17:43，奥威软件 <[email protected] <mailto:[email protected]>> 写道： > > 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 > > >
