您好：
问题一：
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
邮箱：[email protected]
*********************************************************
{
"uuid": "064825ac-62e1-446e-afa9-84a6d227b380",
"last_modified": 1492669019588,
"version": "1.6.0",
"name": "IFAR_CUBE_CM",
"owner": "ADMIN",
"description": "",
"fact_table": "IFAR.V_RP_BALADJOFF_OP",
"lookups": [
{
"table": "IFAR.V_BANK_RP_SUBCUR_OP",
"join": {
"type": "inner",
"primary_key": [
"SUBRPTNUM"
],
"foreign_key": [
"SUBRPTNUM"
]
}
},
{
"table": "IFAR.V_BANK_RP_ORGANCUR_OP",
"join": {
"type": "inner",
"primary_key": [
"ORGCOD"
],
"foreign_key": [
"ORGCOD"
]
}
},
{
"table": "IFAR.RP_COGTALDTE",
"join": {
"type": "inner",
"primary_key": [
"TALDTE"
],
"foreign_key": [
"TALDTE"
]
}
},
{
"table": "IFAR.RP_CCY_OP",
"join": {
"type": "inner",
"primary_key": [
"CCY"
],
"foreign_key": [
"CCY"
]
}
},
{
"table": "IFAR.RP_COGTYP",
"join": {
"type": "inner",
"primary_key": [
"TYP"
],
"foreign_key": [
"TYP"
]
}
}
],
"dimensions": [
{
"table": "IFAR.V_RP_BALADJOFF_OP",
"columns": [
"TALDTE",
"TYP",
"ORGCOD",
"CCY",
"SUBRPTNUM"
]
},
{
"table": "IFAR.V_BANK_RP_SUBCUR_OP",
"columns": [
"SUBRPTNAM1",
"SUBRPTNAM2"
]
},
{
"table": "IFAR.V_BANK_RP_ORGANCUR_OP",
"columns": [
"ACTNAM1",
"ACTNAM2",
"ACTNAM3",
"ACTNAM4"
]
},
{
"table": "IFAR.RP_COGTALDTE",
"columns": [
"TALNAM"
]
},
{
"table": "IFAR.RP_CCY_OP",
"columns": [
"CCYNAM"
]
},
{
"table": "IFAR.RP_COGTYP",
"columns": [
"TYPNAM"
]
}
],
"metrics": [
"BAL",
"DAYBAL",
"TOTDAYBAL"
],
"filter_condition": "",
"partition_desc": {
"partition_date_column": "IFAR.V_RP_BALADJOFF_OP.TALDTE",
"partition_time_column": null,
"partition_date_start": 0,
"partition_date_format": "yyyyMMdd",
"partition_time_format": "HH:mm:ss",
"partition_type": "APPEND",
"partition_condition_builder":
"org.apache.kylin.metadata.model.PartitionDesc$DefaultPartitionConditionBuilder"
},
"capacity": "MEDIUM"
}{
"uuid": "9f4fdffe-4bfd-41ee-a23a-8e5616128273",
"last_modified": 1493000774282,
"version": "1.6.0",
"name": "IFAR_CUBE_CM_1",
"model_name": "IFAR_CUBE_CM",
"description": "",
"null_string": null,
"dimensions": [
{
"name": "SUBCUR_OP_DERIVE",
"table": "IFAR.V_BANK_RP_SUBCUR_OP",
"column": null,
"derived": [
"SUBRPTNAM1",
"SUBRPTNAM2"
]
},
{
"name": "ORGANCUR_OP_DERIVE",
"table": "IFAR.V_BANK_RP_ORGANCUR_OP",
"column": null,
"derived": [
"ACTNAM1",
"ACTNAM2",
"ACTNAM3",
"ACTNAM4"
]
},
{
"name": "COGTALDTE_DERIVE",
"table": "IFAR.RP_COGTALDTE",
"column": null,
"derived": [
"TALNAM"
]
},
{
"name": "CCY_OP_DERIVE",
"table": "IFAR.RP_CCY_OP",
"column": null,
"derived": [
"CCYNAM"
]
},
{
"name": "COGTYP_DERIVE",
"table": "IFAR.RP_COGTYP",
"column": null,
"derived": [
"TYPNAM"
]
}
],
"measures": [
{
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "BAL_SUM",
"function": {
"expression": "RAW",
"parameter": {
"type": "column",
"value": "BAL",
"next_parameter": null
},
"returntype": "raw"
},
"dependent_measure_ref": null
},
{
"name": "DAYBAL_SUM",
"function": {
"expression": "RAW",
"parameter": {
"type": "column",
"value": "DAYBAL",
"next_parameter": null
},
"returntype": "raw"
},
"dependent_measure_ref": null
},
{
"name": "TOTDAYBAL_SUM",
"function": {
"expression": "RAW",
"parameter": {
"type": "column",
"value": "TOTDAYBAL",
"next_parameter": null
},
"returntype": "raw"
},
"dependent_measure_ref": null
}
],
"dictionaries": [],
"rowkey": {
"rowkey_columns": [
{
"column": "SUBRPTNUM",
"encoding": "dict",
"isShardBy": false
},
{
"column": "ORGCOD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "TALDTE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "CCY",
"encoding": "dict",
"isShardBy": false
},
{
"column": "TYP",
"encoding": "dict",
"isShardBy": false
}
]
},
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"_COUNT_",
"BAL_SUM",
"DAYBAL_SUM",
"TOTDAYBAL_SUM"
]
}
]
}
]
},
"aggregation_groups": [
{
"includes": [
"SUBRPTNUM",
"ORGCOD",
"TALDTE",
"CCY",
"TYP"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [],
"joint_dims": []
}
}
],
"signature": "6IutDaBTknw4nQWhojJAbg==",
"notify_list": [],
"status_need_notify": [
"ERROR",
"DISCARDED",
"SUCCEED"
],
"partition_date_start": 0,
"partition_date_end": 3153600000000,
"auto_merge_time_ranges": [
604800000,
2419200000
],
"retention_range": 0,
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {}
}
