You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 程 万胜 <ch...@hotmail.com> on 2017/08/24 03:44:14 UTC
答复: where OPS_REGION=lower('Shanghai') ERROR
it's fine if no LOWER function used!
________________________________
发件人: Billy Liu <bi...@apache.org>
发送时间: 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 程 万胜 <ch...@hotmail.com>>:
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.percentile.PercentileAggFunc'
},
{
name: 'INTERSECT_COUNT',
className: 'org.apache.kylin.measure.bitmap.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<http://DEFAULT.KYLIN_COUNTRY.NAME>, BUYER_COUNTRY:DEFAULT.KYLIN_COUNTRY.NAME<http://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<http://DEFAULT.KYLIN_COUNTRY.NAME>, SELLER_COUNTRY:DEFAULT.KYLIN_COUNTRY.NAME<http://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<http://DEFAULT.KYLIN_COUNTRY.NAME>, BUYER_COUNTRY:DEFAULT.KYLIN_COUNTRY.NAME<http://DEFAULT.KYLIN_COUNTRY.NAME>], filterD=[DEFAULT.KYLIN_SALES.OPS_REGION], limitPushdown=2147483647<tel: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(AvaticaStatement.java:218)
at org.apache.kylin.rest.service.QueryService.execute(QueryService.java:768)
at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(QueryService.java:507)
at org.apache.kylin.rest.service.QueryService.query(QueryService.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(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:110)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.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.processRequest(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.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:316)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:213)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: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<http://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
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(CubeDimEncMap.java:86)
at org.apache.kylin.dict.BuiltInFunctionTransformer.translateCompareTupleFilter(BuiltInFunctionTransformer.java:130)
at org.apache.kylin.dict.BuiltInFunctionTransformer.transform(BuiltInFunctionTransformer.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.queryStorage(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$TakeWhileEnumerator.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(AbstractEnumerable.java:33)
at org.apache.calcite.avatica.MetaImpl.createCursor(MetaImpl.java:89)
at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:196)
at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:67)
at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:44)
at org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:607)
at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:600)
at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(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 :
Re: 答复: where OPS_REGION=lower('Shanghai') ERROR
Posted by Billy Liu <bi...@apache.org>.
Could you file a JIRA to track this issue?
2017-08-24 11:44 GMT+08:00 程 万胜 <ch...@hotmail.com>:
> it's fine if no LOWER function used!
>
> ------------------------------
> *发件人:* Billy Liu <bi...@apache.org>
> *发送时间:* 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 程 万胜 <ch...@hotmail.com>:
>
>> 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 :
>>
>>
>