kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Billy Liu <billy...@apache.org>
Subject Re: where OPS_REGION=lower('Shanghai') ERROR
Date Thu, 24 Aug 2017 02:44:25 GMT
What happened if no LOWER function used?

2017-08-21 11:05 GMT+08:00 程 万胜 <chivise.cn@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, 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(
> 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(SecurityContextPersistenceFilt
> er.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.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 :
>
>

Mime
View raw message