Could you file a JIRA to track this issue? 2017-08-24 11:44 GMT+08:00 程 万胜 <[email protected]>:
> it's fine if no LOWER function used! > > ------------------------------ > *发件人:* Billy Liu <[email protected]> > *发送时间:* 2017年8月24日 10:44 > *收件人:* user > *主题:* Re: where OPS_REGION=lower('Shanghai') ERROR > > What happened if no LOWER function used? > > 2017-08-21 11:05 GMT+08:00 程 万胜 <[email protected]>: > >> hello all: >> >> >> error log: >> >> >> 2017-08-21 10:26:32,624 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> service.QueryService:366 : Using project: learn_kylin >> 2017-08-21 10:26:32,625 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> service.QueryService:367 : The original query: select * from KYLIN_SALES >> where OPS_REGION=lower('Shanghai') >> 2017-08-21 10:26:32,630 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> service.QueryService:493 : The corrected query: select * from KYLIN_SALES >> where OPS_REGION=lower('Shanghai') >> LIMIT 50000 >> 2017-08-21 10:26:32,632 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> schema.OLAPSchemaFactory:116 : Schema json:{ >> "version": "1.0", >> "defaultSchema": "DEFAULT", >> "schemas": [ >> { >> "type": "custom", >> "name": "DEFAULT", >> "factory": "org.apache.kylin.query.schema.OLAPSchemaFactory", >> "operand": { >> "project": "LEARN_KYLIN" >> }, >> "functions": [ >> { >> name: 'PERCENTILE', >> className: 'org.apache.kylin.measure.perc >> entile.PercentileAggFunc' >> }, >> { >> name: 'INTERSECT_COUNT', >> className: 'org.apache.kylin.measure.bitm >> ap.BitmapIntersectDistinctCountAggFunc' >> }, >> { >> name: 'MASSIN', >> className: 'org.apache.kylin.query.udf.MassInUDF' >> }, >> { >> name: 'CONCAT', >> className: 'org.apache.kylin.query.udf.ConcatUDF' >> }, >> { >> name: 'VERSION', >> className: 'org.apache.kylin.query.udf.VersionUDF' >> } >> ] >> } >> ] >> } >> 2017-08-21 10:26:32,685 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> routing.QueryRouter:56 : Find candidates by table DEFAULT.KYLIN_SALES and >> project=LEARN_KYLIN : CUBE[name=kylin_sales_cube] >> 2017-08-21 10:26:32,686 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.routing >> .rules.RemoveBlackoutRealizationsRule, realizations before: >> [kylin_sales_cube(CUBE)], realizations after: [kylin_sales_cube(CUBE)] >> 2017-08-21 10:26:32,686 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.routing >> .rules.RemoveUncapableRealizationsRule, realizations before: >> [kylin_sales_cube(CUBE)], realizations after: [kylin_sales_cube(CUBE)] >> 2017-08-21 10:26:32,686 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> rules.RealizationSortRule:40 : CUBE[name=kylin_sales_cube] priority 1 cost >> 83600. >> 2017-08-21 10:26:32,686 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> routing.QueryRouter:51 : Applying rule: class >> org.apache.kylin.query.routing.rules.RealizationSortRule, >> realizations before: [kylin_sales_cube(CUBE)], realizations after: >> [kylin_sales_cube(CUBE)] >> 2017-08-21 10:26:32,687 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> routing.QueryRouter:68 : The realizations remaining: >> [kylin_sales_cube(CUBE)] And the final chosen one is the first one >> 2017-08-21 10:26:32,714 DEBUG [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> enumerator.OLAPEnumerator:109 : query storage... >> 2017-08-21 10:26:32,714 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:42 : No group by and aggregation found in this >> query, will hack some result for better look of output... >> 2017-08-21 10:26:32,714 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> SELLER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_ID, output will be >> meaningless. >> 2017-08-21 10:26:32,715 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_ID, output will be >> meaningless. >> 2017-08-21 10:26:32,715 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID, output will be >> meaningless. >> 2017-08-21 10:26:32,715 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.USER_DEFINED_FIELD3, output will be >> meaningless. >> 2017-08-21 10:26:32,715 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.USER_DEFINED_FIELD1, output will be >> meaningless. >> 2017-08-21 10:26:32,716 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.SITE_ID, output will be meaningless. >> 2017-08-21 10:26:32,716 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CAL_DT.CAL_DT, output will be meaningless. >> 2017-08-21 10:26:32,716 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CAL_DT.MONTH_BEG_DT, output will be meaningless. >> 2017-08-21 10:26:32,716 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> SELLER_COUNTRY:DEFAULT.KYLIN_COUNTRY.COUNTRY, output will be meaningless. >> 2017-08-21 10:26:32,717 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> BUYER_COUNTRY:DEFAULT.KYLIN_COUNTRY.COUNTRY, output will be meaningless. >> 2017-08-21 10:26:32,717 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CAL_DT.YEAR_BEG_DT, output will be meaningless. >> 2017-08-21 10:26:32,717 WARN [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> cube.RawQueryLastHacker:73 : SUM is not defined for measure column >> DEFAULT.KYLIN_CAL_DT.WEEK_BEG_DT, output will be meaningless. >> 2017-08-21 10:26:32,717 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> topn.TopNMeasureType:339 : Rewrite function FunctionDesc [expression=SUM, >> parameter=DEFAULT.KYLIN_SALES.PRICE, returnType=null] to FunctionDesc >> [expression=TOP_N, parameter=DEFAULT.KYLIN_SALES. >> PRICE,DEFAULT.KYLIN_SALES.SELLER_ID, returnType=topn(100, 6)] >> 2017-08-21 10:26:32,718 DEBUG [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> gtrecord.GTCubeStorageQueryBase:264 : Need storage aggregation >> 2017-08-21 10:26:32,718 DEBUG [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> gtrecord.GTCubeStorageQueryBase:353 : Storage limit push down is >> impossible because the filter isn't evaluable >> 2017-08-21 10:26:32,718 DEBUG [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> gtrecord.GTCubeStorageQueryBase:376 : Storage limit push down is >> impossible because groupD is not clustered at head, groupsD: >> [DEFAULT.KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, >> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_BUYER_LEVEL, >> DEFAULT.KYLIN_SALES.PART_DT, >> SELLER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_SELLER_LEVEL, >> DEFAULT.KYLIN_SALES.LEAF_CATEG_ID, DEFAULT.KYLIN_SALES.LSTG_FORMAT_NAME, >> DEFAULT.KYLIN_SALES.TRANS_ID, DEFAULT.KYLIN_SALES.OPS_USER_ID, >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME, >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME, >> DEFAULT.KYLIN_SALES.LSTG_SITE_ID, DEFAULT.KYLIN_SALES.OPS_REGION, >> DEFAULT.KYLIN_SALES.BUYER_ID, >> SELLER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_COUNTRY, >> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_COUNTRY, SELLER_COUNTRY: >> DEFAULT.KYLIN_COUNTRY.NAME, BUYER_COUNTRY:DEFAULT.KYLIN_COUNTRY.NAME] >> with cuboid columns: [DEFAULT.KYLIN_SALES.BUYER_ID, >> DEFAULT.KYLIN_SALES.SELLER_ID, DEFAULT.KYLIN_SALES.TRANS_ID, >> DEFAULT.KYLIN_SALES.PART_DT, DEFAULT.KYLIN_SALES.LEAF_CATEG_ID, >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME, >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME, >> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_BUYER_LEVEL, >> SELLER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_SELLER_LEVEL, >> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_COUNTRY, >> SELLER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_COUNTRY, BUYER_COUNTRY: >> DEFAULT.KYLIN_COUNTRY.NAME, SELLER_COUNTRY:DEFAULT.KYLIN_COUNTRY.NAME, >> DEFAULT.KYLIN_SALES.LSTG_FORMAT_NAME, DEFAULT.KYLIN_SALES.LSTG_SITE_ID, >> DEFAULT.KYLIN_SALES.OPS_USER_ID, DEFAULT.KYLIN_SALES.OPS_REGION] >> 2017-08-21 10:26:32,719 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> gtrecord.GTCubeStorageQueryBase:155 : Cuboid identified: >> cube=kylin_sales_cube, cuboidId=262143, >> groupsD=[DEFAULT.KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME, >> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_BUYER_LEVEL, >> DEFAULT.KYLIN_SALES.PART_DT, >> SELLER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_SELLER_LEVEL, >> DEFAULT.KYLIN_SALES.LEAF_CATEG_ID, DEFAULT.KYLIN_SALES.LSTG_FORMAT_NAME, >> DEFAULT.KYLIN_SALES.TRANS_ID, DEFAULT.KYLIN_SALES.OPS_USER_ID, >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME, >> DEFAULT.KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME, >> DEFAULT.KYLIN_SALES.LSTG_SITE_ID, DEFAULT.KYLIN_SALES.OPS_REGION, >> DEFAULT.KYLIN_SALES.BUYER_ID, >> SELLER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_COUNTRY, >> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_COUNTRY, SELLER_COUNTRY: >> DEFAULT.KYLIN_COUNTRY.NAME, BUYER_COUNTRY:DEFAULT.KYLIN_COUNTRY.NAME], >> filterD=[DEFAULT.KYLIN_SALES.OPS_REGION], limitPushdown=2147483647 >> <021%204748%203647>, storageAggr=true >> 2017-08-21 10:26:32,719 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for segment >> 20120101000000_20170801010500 >> 2017-08-21 10:26:32,719 ERROR [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> service.QueryService:421 : Exception when execute sql >> java.sql.SQLException: Error while executing SQL "select * from >> KYLIN_SALES where OPS_REGION=lower('Shanghai') >> LIMIT 50000": null >> 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(Ava >> ticaStatement.java:218) >> at org.apache.kylin.rest.service.QueryService.execute(QueryServ >> ice.java:768) >> at org.apache.kylin.rest.service.QueryService.queryWithSqlMassa >> ge(QueryService.java:507) >> at org.apache.kylin.rest.service.QueryService.query(QueryServic >> e.java:177) >> at org.apache.kylin.rest.service.QueryService.doQueryWithCache( >> QueryService.java:387) >> at org.apache.kylin.rest.controller.QueryController.query( >> QueryController.java:78) >> at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe >> thodAccessorImpl.java:43) >> at java.lang.reflect.Method.invoke(Method.java:606) >> at org.springframework.web.method.support.InvocableHandlerMetho >> d.doInvoke(InvocableHandlerMethod.java:221) >> at org.springframework.web.method.support.InvocableHandlerMetho >> d.invokeForRequest(InvocableHandlerMethod.java:136) >> at org.springframework.web.servlet.mvc.method.annotation.Servle >> tInvocableHandlerMethod.invokeAndHandle(ServletInvocableHand >> lerMethod.java:110) >> at org.springframework.web.servlet.mvc.method.annotation.Reques >> tMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHan >> dlerAdapter.java:832) >> at org.springframework.web.servlet.mvc.method.annotation.Reques >> tMappingHandlerAdapter.handleInternal(RequestMappingHandlerA >> dapter.java:743) >> at org.springframework.web.servlet.mvc.method.AbstractHandlerMe >> thodAdapter.handle(AbstractHandlerMethodAdapter.java:85) >> at org.springframework.web.servlet.DispatcherServlet.doDispatch >> (DispatcherServlet.java:961) >> at org.springframework.web.servlet.DispatcherServlet.doService( >> DispatcherServlet.java:895) >> at org.springframework.web.servlet.FrameworkServlet.processRequ >> est(FrameworkServlet.java:967) >> at org.springframework.web.servlet.FrameworkServlet.doPost( >> FrameworkServlet.java:869) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) >> at org.springframework.web.servlet.FrameworkServlet.service( >> FrameworkServlet.java:843) >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi >> lter(ApplicationFilterChain.java:303) >> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App >> licationFilterChain.java:208) >> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilte >> r.java:52) >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi >> lter(ApplicationFilterChain.java:241) >> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App >> licationFilterChain.java:208) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:316) >> at org.springframework.security.web.access.intercept.FilterSecu >> rityInterceptor.invoke(FilterSecurityInterceptor.java:126) >> at org.springframework.security.web.access.intercept.FilterSecu >> rityInterceptor.doFilter(FilterSecurityInterceptor.java:90) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.access.ExceptionTranslation >> Filter.doFilter(ExceptionTranslationFilter.java:114) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.session.SessionManagementFi >> lter.doFilter(SessionManagementFilter.java:122) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.authentication.AnonymousAut >> henticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.servletapi.SecurityContextH >> olderAwareRequestFilter.doFilter(SecurityContextHolder >> AwareRequestFilter.java:169) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.savedrequest.RequestCacheAw >> areFilter.doFilter(RequestCacheAwareFilter.java:48) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.authentication.www.BasicAut >> henticationFilter.doFilterInternal(BasicAuthenticationFilter.java:213) >> at org.springframework.web.filter.OncePerRequestFilter.doFilter >> (OncePerRequestFilter.java:107) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.authentication.AbstractAuth >> enticationProcessingFilter.doFilter(AbstractAuthenticatio >> nProcessingFilter.java:205) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.authentication.logout.Logou >> tFilter.doFilter(LogoutFilter.java:120) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.header.HeaderWriterFilter.d >> oFilterInternal(HeaderWriterFilter.java:64) >> at org.springframework.web.filter.OncePerRequestFilter.doFilter >> (OncePerRequestFilter.java:107) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.context.request.async.WebAs >> yncManagerIntegrationFilter.doFilterInternal(WebAsyncManag >> erIntegrationFilter.java:53) >> at org.springframework.web.filter.OncePerRequestFilter.doFilter >> (OncePerRequestFilter.java:107) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.context.SecurityContextPers >> istenceFilter.doFilter(SecurityContextPersistenceFilter.java:91) >> at org.springframework.security.web.FilterChainProxy$VirtualFil >> terChain.doFilter(FilterChainProxy.java:330) >> at org.springframework.security.web.FilterChainProxy.doFilterIn >> ternal(FilterChainProxy.java:213) >> at org.springframework.security.web.FilterChainProxy.doFilter(F >> ilterChainProxy.java:176) >> at org.springframework.web.filter.DelegatingFilterProxy.invokeD >> elegate(DelegatingFilterProxy.java:346) >> at org.springframework.web.filter.DelegatingFilterProxy.doFilte >> r(DelegatingFilterProxy.java:262) >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi >> lter(ApplicationFilterChain.java:241) >> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App >> licationFilterChain.java:208) >> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilte >> r.java:209) >> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilte >> r.java:244) >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFi >> lter(ApplicationFilterChain.java:241) >> at org.apache.catalina.core.ApplicationFilterChain.doFilter(App >> licationFilterChain.java:208) >> at org.apache.catalina.core.StandardWrapperValve.invoke(Standar >> dWrapperValve.java:220) >> at org.apache.catalina.core.StandardContextValve.invoke(Standar >> dContextValve.java:122) >> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(A >> uthenticatorBase.java:505) >> at org.apache.catalina.core.StandardHostValve.invoke(StandardHo >> stValve.java:169) >> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo >> rtValve.java:103) >> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogVa >> lve.java:956) >> at org.apache.catalina.core.StandardEngineValve.invoke(Standard >> EngineValve.java:116) >> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd >> apter.java:436) >> at org.apache.coyote.http11.AbstractHttp11Processor.process(Abs >> tractHttp11Processor.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(ThreadPool >> Executor.java:1145) >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo >> lExecutor.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 >> at org.apache.kylin.cube.CubeSegment.getDictResPath(CubeSegment >> .java:299) >> at org.apache.kylin.cube.CubeManager.getDictionary(CubeManager. >> java:269) >> at org.apache.kylin.cube.CubeSegment.getDictionary(CubeSegment. >> java:331) >> at org.apache.kylin.cube.kv.CubeDimEncMap.getDictionary(CubeDim >> EncMap.java:86) >> at org.apache.kylin.dict.BuiltInFunctionTransformer.translateCo >> mpareTupleFilter(BuiltInFunctionTransformer.java:130) >> at org.apache.kylin.dict.BuiltInFunctionTransformer.transform(B >> uiltInFunctionTransformer.java:61) >> at org.apache.kylin.storage.gtrecord.CubeSegmentScanner.<init>( >> CubeSegmentScanner.java:69) >> at org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase. >> search(GTCubeStorageQueryBase.java:88) >> at org.apache.kylin.query.enumerator.OLAPEnumerator.queryStorag >> e(OLAPEnumerator.java:120) >> at org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext( >> OLAPEnumerator.java:64) >> at Baz$1$1.moveNext(Unknown Source) >> at org.apache.calcite.linq4j.EnumerableDefaults$TakeWhileEnumer >> ator.moveNext(EnumerableDefaults.java:2952) >> at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.<init>( >> Linq4j.java:664) >> at org.apache.calcite.linq4j.Linq4j.enumeratorIterator(Linq4j. >> java:98) >> at org.apache.calcite.linq4j.AbstractEnumerable.iterator(Abstra >> ctEnumerable.java:33) >> at org.apache.calcite.avatica.MetaImpl.createCursor(MetaImpl.java:89) >> at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaR >> esultSet.java:196) >> at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResu >> ltSet.java:67) >> at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResu >> ltSet.java:44) >> at org.apache.calcite.avatica.AvaticaConnection$1.execute(Avati >> caConnection.java:607) >> at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(Ca >> lciteMetaImpl.java:600) >> at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecu >> teInternal(AvaticaConnection.java:615) >> at org.apache.calcite.avatica.AvaticaStatement.executeInternal( >> AvaticaStatement.java:148) >> ... 81 more >> 2017-08-21 10:26:32,720 INFO [Query 4bb70ccb-68e7-4b11-965f-e3d8e8bfd5d9-82] >> service.QueryService:284 : >> >> >
