You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 奥威软件 <35...@qq.com> on 2019/10/28 10:58:03 UTC
strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
Hi,
I finally found out how to do set cube, not only model.
and I found another problem:
I can't not set more than one count(1) function,
that means i can't use multiple columns for count() function.
or you may got this as below:
ERROR : Must define one and only one count(1) function, but there are 2 -- [FunctionDesc
[expression=COUNT, parameter=1, returnType=bigint], FunctionDesc [expression=COUNT, parameter=1, returnType=bigint]]
so I hope the exception can be fixed as I submitted before .
THX !
------------------ 原始邮件 ------------------
发件人: "Wang rupeng"<wa...@live.cn>;
发送时间: 2019年10月28日(星期一) 晚上6:41
收件人: "user@kylin.apache.org"<us...@kylin.apache.org>;
抄送: "奥威软件"<35...@qq.com>;
主题: Re: 回复： strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
Hi,
Find your model on the right of the kylin page, then edit your model, you will see the Model Designer. There are 5 steps, the 4th is called “Measures”, then add the column. But first you need to remove the column from the 3rd step.
发件人: 奥威软件 <35...@qq.com>
答复: <us...@kylin.apache.org>
日期: 2019年10月28日 星期一 16:44
收件人: kylin_user <us...@kylin.apache.org>
主题: 回复： strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
Hi,
the picture was broken.
i don't know how to make add "KYLIN_SALES.LSTG_FORMAT_NAME" as measures to cube, i got sum string type error
can you explain how to build cube with "KYLIN_SALES.LSTG_FORMAT_NAME" as measures;
------------------ 原始邮件 ------------------
发件人: "Wang rupeng"<wa...@live.cn>;
发送时间: 2019年10月28日(星期一) 中午1:45
收件人: "user@kylin.apache.org"<us...@kylin.apache.org>;
主题: Re: strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
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’.
发件人: 奥威软件 <35...@qq.com>
答复: <us...@kylin.apache.org>
日期: 2019年10月26日 星期六 17:43
收件人: kylin_user <us...@kylin.apache.org>
主题: 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
Re: strange error! java.lang.IndexOutOfBoundsException: Index:
43,Size: 43 appear in double select sql query
Posted by Wang rupeng <wa...@live.cn>.
Surely, there would be only one count(1) function. Kylin has two kind of count functions, one is count constant and the other is count exact column. You can add a measure then choose count function and you should also choose the “Param Type”as “column”, then you can count the column you want.
[cid:image001.png@01D58DC8.AF3E77E0]
发件人: 奥威软件 <35...@qq.com>
答复: <us...@kylin.apache.org>
日期: 2019年10月28日 星期一 19:37
收件人: user <us...@kylin.apache.org>
主题: strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
Hi,
I finally found out how to do set cube, not only model.
and I found another problem:
I can't not set more than one count(1) function,
that means i can't use multiple columns for count() function.
[cid:image002.png@01D58DC8.AF3E77E0]
or you may got this as below:
ERROR : Must define one and only one count(1) function, but there are 2 -- [FunctionDesc
[expression=COUNT, parameter=1, returnType=bigint], FunctionDesc [expression=COUNT, parameter=1, returnType=bigint]]
so I hope the exception can be fixed as I submitted before .
THX !
------------------ 原始邮件 ------------------
发件人: "Wang rupeng"<wa...@live.cn>;
发送时间: 2019年10月28日(星期一) 晚上6:41
收件人: "user@kylin.apache.org"<us...@kylin.apache.org>;
抄送: "奥威软件"<35...@qq.com>;
主题: Re: 回复： strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
Hi,
Find your model on the right of the kylin page, then edit your model, you will see the Model Designer. There are 5 steps, the 4th is called “Measures”, then add the column. But first you need to remove the column from the 3rd step.
[cid:1355F1A7@E0559508.BBC9B65D]
[cid:BCA0CE36@80C3EA2C.BBC9B65D]
[cid:AA2AF6DB@43EF9E28.BBC9B65D]
发件人: 奥威软件 <35...@qq.com>
答复: <us...@kylin.apache.org>
日期: 2019年10月28日 星期一 16:44
收件人: kylin_user <us...@kylin.apache.org>
主题: 回复： strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
Hi,
the picture was broken.
i don't know how to make add "KYLIN_SALES.LSTG_FORMAT_NAME" as measures to cube, i got sum string type error
can you explain how to build cube with "KYLIN_SALES.LSTG_FORMAT_NAME" as measures;
------------------ 原始邮件 ------------------
发件人: "Wang rupeng"<wa...@live.cn>;
发送时间: 2019年10月28日(星期一) 中午1:45
收件人: "user@kylin.apache.org"<us...@kylin.apache.org>;
主题: Re: strange error! java.lang.IndexOutOfBoundsException: Index: 43,Size: 43 appear in double select sql query
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’.
[cid:3E739362@29F6C85A.BBC9B65D]
[cid:ADFD5998@823A310B.BBC9B65D]
发件人: 奥威软件 <35...@qq.com>
答复: <us...@kylin.apache.org>
日期: 2019年10月26日 星期六 17:43
收件人: kylin_user <us...@kylin.apache.org>
主题: 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