You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by ch...@abchina.com on 2017/04/24 07:30:24 UTC
Query Error
您好:
问题一:
kylin如何实现明细查询?换句话说,如果维度是多层级的情况,上层维度不会根
据下层维度进行汇总。目前想到的是用kylin的raw measure。
想问下用Kylin的raw measure是不是就是为了实现明细查询,为什么现在又不推
荐了?另外我发现mondrain目前并不支持raw这个关键词的解析,如何解决?
问题二:
我使用kylin设计了一个model,一共一个事实表五个维度表,并基于此model设计
了一个cube(三个指标均设置为RAW类型),两者结构如下:
Cube生成之后,在前台insight中进行查询:
select *
from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
"V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
join "V_BANK_RP_ORGANCUR_OP" as "V_BANK_RP_ORGANCUR_OP" on
"V_RP_BALADJOFF_OP"."ORGCOD" = "V_BANK_RP_ORGANCUR_OP"."ORGCOD"
join "RP_CCY_OP" as "RP_CCY_OP" on "V_RP_BALADJOFF_OP"."CCY" =
"RP_CCY_OP"."CCY"
join "RP_COGTALDTE" as "RP_COGTALDTE" on
"V_RP_BALADJOFF_OP"."TALDTE"="RP_COGTALDTE"."TALDTE"
join "RP_COGTYP" as "RP_COGTYP" on
"V_RP_BALADJOFF_OP"."TYP"="RP_COGTYP"."TYP"
发现只要关联标红的这张表,查询就会报错,如果不关联这张表就能正常查询,报错
日志如下:
2017-04-24 15:09:26,085 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] service.QueryService:336 :
Using project: IFAR
2017-04-24 15:09:26,085 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] service.QueryService:337 : The
original query: select *
from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
"V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
2017-04-24 15:09:26,086 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] service.QueryService:440 : The
corrected query: select *
from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
"V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
LIMIT 50
2017-04-24 15:09:26,109 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:48 : The
project manager's reference is
org.apache.kylin.metadata.project.ProjectManager@630ea6f1
2017-04-24 15:09:26,109 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:60 : Find
candidates by table IFAR.V_BANK_RP_SUBCUR_OP and project=IFAR :
CUBE[name=IFAR_CUBE_CM_1]
2017-04-24 15:09:26,109 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:51 :
Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before: [IFAR_CUBE_CM_1(CUBE)], realizations after:
[IFAR_CUBE_CM_1(CUBE)]
2017-04-24 15:09:26,109 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:51 :
Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before: [IFAR_CUBE_CM_1(CUBE)], realizations after:
[IFAR_CUBE_CM_1(CUBE)]
2017-04-24 15:09:26,110 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] rules.RealizationSortRule:40 :
CUBE[name=IFAR_CUBE_CM_1] priority 1 cost 604.
2017-04-24 15:09:26,110 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:51 :
Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations
before: [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
2017-04-24 15:09:26,110 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:72 : The
realizations remaining: [IFAR_CUBE_CM_1(CUBE)] And the final chosen one is
the first one
2017-04-24 15:09:26,110 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:48 : The
project manager's reference is
org.apache.kylin.metadata.project.ProjectManager@630ea6f1
2017-04-24 15:09:26,110 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:60 : Find
candidates by table IFAR.V_RP_BALADJOFF_OP and project=IFAR :
CUBE[name=IFAR_CUBE_CM_1]
2017-04-24 15:09:26,111 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:51 :
Applying rule: class
org.apache.kylin.query.routing.rules.RemoveBlackoutRealizationsRule,
realizations before: [IFAR_CUBE_CM_1(CUBE)], realizations after:
[IFAR_CUBE_CM_1(CUBE)]
2017-04-24 15:09:26,111 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] cube.CubeCapabilityChecker:191
: Cube CUBE[name=IFAR_CUBE_CM_1] CapabilityInfluences: BAL_SUM@class
org.apache.kylin.measure.raw.RawMeasureType,DAYBAL_SUM@class
org.apache.kylin.measure.raw.RawMeasureType,TOTDAYBAL_SUM@class
org.apache.kylin.measure.raw.RawMeasureType
2017-04-24 15:09:26,111 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:51 :
Applying rule: class
org.apache.kylin.query.routing.rules.RemoveUncapableRealizationsRule,
realizations before: [IFAR_CUBE_CM_1(CUBE)], realizations after:
[IFAR_CUBE_CM_1(CUBE)]
2017-04-24 15:09:26,111 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] rules.RealizationSortRule:40 :
CUBE[name=IFAR_CUBE_CM_1] priority 1 cost 43900.
2017-04-24 15:09:26,112 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:51 :
Applying rule: class
org.apache.kylin.query.routing.rules.RealizationSortRule, realizations
before: [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
2017-04-24 15:09:26,112 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] routing.QueryRouter:72 : The
realizations remaining: [IFAR_CUBE_CM_1(CUBE)] And the final chosen one is
the first one
2017-04-24 15:09:26,136 DEBUG [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] enumerator.OLAPEnumerator:100
: query storage...
2017-04-24 15:09:26,136 ERROR [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] service.QueryService:372 :
Exception when execute sql
java.sql.SQLException: Error while executing SQL "select *
from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
"V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
LIMIT 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row
key desc
at
org.apache.calcite.avatica.Helper.createException(Helper.java:56)
at
org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:147)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:208)
at
org.apache.kylin.rest.service.QueryService.execute(QueryService.java:538)
at
org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:452)
at
org.apache.kylin.rest.service.QueryService.query(QueryService.java:151)
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:354)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException: Column
IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row key desc
at
org.apache.kylin.cube.model.RowKeyDesc.getColDesc(RowKeyDesc.java:65)
at
org.apache.kylin.cube.model.RowKeyDesc.getColumnBitIndex(RowKeyDesc.java:59)
at
org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.java:65)
at
org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104)
at
org.apache.kylin.query.enumerator.OLAPEnumerator.queryStorage(OLAPEnumerator.java:114)
at
org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:65)
at
org.apache.calcite.linq4j.EnumerableDefaults.toLookup_(EnumerableDefaults.java:2690)
at
org.apache.calcite.linq4j.EnumerableDefaults.toLookup(EnumerableDefaults.java:2682)
at
org.apache.calcite.linq4j.EnumerableDefaults.toLookup(EnumerableDefaults.java:2658)
at
org.apache.calcite.linq4j.DefaultEnumerable.toLookup(DefaultEnumerable.java:701)
at
org.apache.calcite.linq4j.EnumerableDefaults$10.enumerator(EnumerableDefaults.java:1092)
at Baz$5$1.<init>(Unknown Source)
at Baz$5.enumerator(Unknown Source)
at
org.apache.calcite.linq4j.EnumerableDefaults$26.enumerator(EnumerableDefaults.java:2494)
at
org.apache.calcite.linq4j.AbstractEnumerable.iterator(AbstractEnumerable.java:33)
at
org.apache.calcite.avatica.MetaImpl.createCursor(MetaImpl.java:85)
at
org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:190)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:65)
at
org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:44)
at
org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:605)
at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:599)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:613)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:139)
... 76 more
2017-04-24 15:09:26,137 INFO [Query
81afd783-bc9b-47f8-87f5-870ab668479e-12861] service.QueryService:284 :
==========================[QUERY]===============================
Query Id: 81afd783-bc9b-47f8-87f5-870ab668479e
SQL: select *
from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
"V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
LIMIT 50
User: IFARUSR
Success: false
Duration: 0.0
Project: IFAR
Realization Names: [IFAR_CUBE_CM_1]
Cuboid Ids: []
Total scan count: 0
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Message: Error while executing SQL "select * from "V_RP_BALADJOFF_OP" as
"V_RP_BALADJOFF_OP" join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP"
on "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
LIMIT 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row
key desc
==========================[QUERY]===============================
2017-04-24 15:09:26,138 ERROR [http-bio-7070-exec-94]
controller.BasicController:44 :
org.apache.kylin.rest.exception.InternalErrorException: Error while
executing SQL "select * from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
"V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" LIMIT
50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row key
desc
at
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:389)
at
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:69)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:91)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
at
com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
*********************************************************
陈萌
中国农业银行软件开发中心应用开发五部
地址:北京市丰台区丽泽路18号院1号楼金唐国际金融大厦801E室
邮编:100073
电话:010-68126752
邮箱:chenmengg@abchina.com
*********************************************************
Re: Query Error
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi chen,
The limitation of the RAW measure was discussed here:
http://apache-kylin.74782.x6.nabble.com/Discuss-Disable-hide-quot-RAW-quot-measure-in-Kylin-web-GUI-td6636.html
Due to these limitations, I personally don't recommend to use it.
2017-04-24 15:30 GMT+08:00 <ch...@abchina.com>:
> 您好:
>
> 问题一:
>
> kylin如何实现明细查询?换句话说,如果维度是多层级的情况,上层维度不会根据下层维度进行汇总。目前想到的是用kylin的raw
> measure。
> 想问下用Kylin的raw measure是不是就是为了实现明细查询,为什么现在又不推荐了?
> 另外我发现mondrain目前并不支持raw这个关键词的解析,如何解决?
>
> 问题二:
>
> 我使用kylin设计了一个model,一共一个事实表五个维度表,并基于此model设计了一个cube(
> 三个指标均设置为RAW类型),两者结构如下:
>
>
>
> Cube生成之后,在前台insight中进行查询:
> select *
> from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
> join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
> "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
> join "V_BANK_RP_ORGANCUR_OP" as "V_BANK_RP_ORGANCUR_OP" on
> "V_RP_BALADJOFF_OP"."ORGCOD" = "V_BANK_RP_ORGANCUR_OP"."ORGCOD"
> join "RP_CCY_OP" as "RP_CCY_OP" on "V_RP_BALADJOFF_OP"."CCY" =
> "RP_CCY_OP"."CCY"
> join "RP_COGTALDTE" as "RP_COGTALDTE" on "V_RP_BALADJOFF_OP"."TALDTE"="
> RP_COGTALDTE"."TALDTE"
> join "RP_COGTYP" as "RP_COGTYP" on "V_RP_BALADJOFF_OP"."TYP"="RP_
> COGTYP"."TYP"
>
> 发现只要关联标红的这张表,查询就会报错,如果不关联这张表就能正常查询,报错日志如下:
>
> 2017-04-24 15:09:26,085 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> service.QueryService:336 : Using project: IFAR
> 2017-04-24 15:09:26,085 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> service.QueryService:337 : The original query: select *
> from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
> join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
> "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
> 2017-04-24 15:09:26,086 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> service.QueryService:440 : The corrected query: select *
> from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
> join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
> "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
> LIMIT 50
> 2017-04-24 15:09:26,109 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:48 : The project manager's reference is
> org.apache.kylin.metadata.project.ProjectManager@630ea6f1
> 2017-04-24 15:09:26,109 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:60 : Find candidates by table IFAR.V_BANK_RP_SUBCUR_OP
> and project=IFAR : CUBE[name=IFAR_CUBE_CM_1]
> 2017-04-24 15:09:26,109 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveBlackoutRealizationsRule, realizations before:
> [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
> 2017-04-24 15:09:26,109 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveUncapableRealizationsRule, realizations before:
> [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
> 2017-04-24 15:09:26,110 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> rules.RealizationSortRule:40 : CUBE[name=IFAR_CUBE_CM_1] priority 1 cost
> 604.
> 2017-04-24 15:09:26,110 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RealizationSortRule, realizations before:
> [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
> 2017-04-24 15:09:26,110 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:72 : The realizations remaining: [IFAR_CUBE_CM_1(CUBE)]
> And the final chosen one is the first one
> 2017-04-24 15:09:26,110 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:48 : The project manager's reference is
> org.apache.kylin.metadata.project.ProjectManager@630ea6f1
> 2017-04-24 15:09:26,110 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:60 : Find candidates by table IFAR.V_RP_BALADJOFF_OP
> and project=IFAR : CUBE[name=IFAR_CUBE_CM_1]
> 2017-04-24 15:09:26,111 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveBlackoutRealizationsRule, realizations before:
> [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
> 2017-04-24 15:09:26,111 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> cube.CubeCapabilityChecker:191 : Cube CUBE[name=IFAR_CUBE_CM_1]
> CapabilityInfluences: BAL_SUM@class org.apache.kylin.measure.raw.
> RawMeasureType,DAYBAL_SUM@class org.apache.kylin.measure.raw.
> RawMeasureType,TOTDAYBAL_SUM@class org.apache.kylin.measure.raw.
> RawMeasureType
> 2017-04-24 15:09:26,111 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveUncapableRealizationsRule, realizations before:
> [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
> 2017-04-24 15:09:26,111 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> rules.RealizationSortRule:40 : CUBE[name=IFAR_CUBE_CM_1] priority 1 cost
> 43900.
> 2017-04-24 15:09:26,112 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RealizationSortRule, realizations before:
> [IFAR_CUBE_CM_1(CUBE)], realizations after: [IFAR_CUBE_CM_1(CUBE)]
> 2017-04-24 15:09:26,112 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> routing.QueryRouter:72 : The realizations remaining: [IFAR_CUBE_CM_1(CUBE)]
> And the final chosen one is the first one
> 2017-04-24 15:09:26,136 DEBUG [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> enumerator.OLAPEnumerator:100 : query storage...
> 2017-04-24 15:09:26,136 ERROR [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> service.QueryService:372 : Exception when execute sql
> java.sql.SQLException: Error while executing SQL "select *
> from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
> join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
> "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
> LIMIT 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row
> key desc
> at org.apache.calcite.avatica.Helper.createException(Helper.
> java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.
> java:41)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:147)
> at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> AvaticaStatement.java:208)
> at org.apache.kylin.rest.service.QueryService.execute(
> QueryService.java:538)
> at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(
> QueryService.java:452)
> at org.apache.kylin.rest.service.QueryService.query(
> QueryService.java:151)
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:354)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> doInvoke(InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:87)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:192)
> at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
> at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:343)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:209)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:244)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
> at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
> at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
> at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
> at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
> at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:615)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException: Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL
> does not exist in row key desc
> at org.apache.kylin.cube.model.RowKeyDesc.getColDesc(
> RowKeyDesc.java:65)
> at org.apache.kylin.cube.model.RowKeyDesc.getColumnBitIndex(
> RowKeyDesc.java:59)
> at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.
> java:65)
> at org.apache.kylin.storage.gtrecord.
> GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:104)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> queryStorage(OLAPEnumerator.java:114)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> moveNext(OLAPEnumerator.java:65)
> at org.apache.calcite.linq4j.EnumerableDefaults.toLookup_(
> EnumerableDefaults.java:2690)
> at org.apache.calcite.linq4j.EnumerableDefaults.toLookup(
> EnumerableDefaults.java:2682)
> at org.apache.calcite.linq4j.EnumerableDefaults.toLookup(
> EnumerableDefaults.java:2658)
> at org.apache.calcite.linq4j.DefaultEnumerable.toLookup(
> DefaultEnumerable.java:701)
> at org.apache.calcite.linq4j.EnumerableDefaults$10.
> enumerator(EnumerableDefaults.java:1092)
> at Baz$5$1.<init>(Unknown Source)
> at Baz$5.enumerator(Unknown Source)
> at org.apache.calcite.linq4j.EnumerableDefaults$26.
> enumerator(EnumerableDefaults.java:2494)
> at org.apache.calcite.linq4j.AbstractEnumerable.iterator(
> AbstractEnumerable.java:33)
> at org.apache.calcite.avatica.MetaImpl.createCursor(
> MetaImpl.java:85)
> at org.apache.calcite.avatica.AvaticaResultSet.execute(
> AvaticaResultSet.java:190)
> at org.apache.calcite.jdbc.CalciteResultSet.execute(
> CalciteResultSet.java:65)
> at org.apache.calcite.jdbc.CalciteResultSet.execute(
> CalciteResultSet.java:44)
> at org.apache.calcite.avatica.AvaticaConnection$1.execute(
> AvaticaConnection.java:605)
> at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(
> CalciteMetaImpl.java:599)
> at org.apache.calcite.avatica.AvaticaConnection.
> prepareAndExecuteInternal(AvaticaConnection.java:613)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:139)
> ... 76 more
> 2017-04-24 15:09:26,137 INFO [Query 81afd783-bc9b-47f8-87f5-870ab668479e-12861]
> service.QueryService:284 :
> ==========================[QUERY]===============================
> Query Id: 81afd783-bc9b-47f8-87f5-870ab668479e
> SQL: select *
> from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
> join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
> "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM"
> LIMIT 50
> User: IFARUSR
> Success: false
> Duration: 0.0
> Project: IFAR
> Realization Names: [IFAR_CUBE_CM_1]
> Cuboid Ids: []
> Total scan count: 0
> Result row count: 0
> Accept Partial: true
> Is Partial Result: false
> Hit Exception Cache: false
> Storage cache used: false
> Message: Error while executing SQL "select * from "V_RP_BALADJOFF_OP" as
> "V_RP_BALADJOFF_OP" join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
> "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" LIMIT
> 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row key
> desc
> ==========================[QUERY]===============================
>
> 2017-04-24 15:09:26,138 ERROR [http-bio-7070-exec-94]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while
> executing SQL "select * from "V_RP_BALADJOFF_OP" as "V_RP_BALADJOFF_OP"
> join "V_BANK_RP_SUBCUR_OP" as "V_BANK_RP_SUBCUR_OP" on
> "V_RP_BALADJOFF_OP"."SUBRPTNUM" = "V_BANK_RP_SUBCUR_OP"."SUBRPTNUM" LIMIT
> 50": Column IFAR.V_RP_BALADJOFF_OP.TOTDAYBAL does not exist in row key
> desc
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:389)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> doInvoke(InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:87)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:192)
> at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
> at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:343)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:209)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:244)
> at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
> at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
> at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
> at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
> at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
> at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:615)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:745)
>
>
> *********************************************************
> 陈萌
> 中国农业银行软件开发中心应用开发五部
> 地址:北京市丰台区丽泽路18号院1号楼金唐国际金融大厦801E室
> 邮编:100073
> 电话:010-68126752 <010%206812%206752>
> 邮箱:chenmengg@abchina.com
> *********************************************************
--
Best regards,
Shaofeng Shi 史少锋