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
