Return-Path: <user-return-2236-archive-asf-public=cust-asf.ponee.io@kylin.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 3238D200CFC
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Thu, 24 Aug 2017 04:44:51 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 3052916A360; Thu, 24 Aug 2017 02:44:51 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id 492C016A35D
	for <archive-asf-public@cust-asf.ponee.io>; Thu, 24 Aug 2017 04:44:49 +0200 (CEST)
Received: (qmail 27550 invoked by uid 500); 24 Aug 2017 02:44:48 -0000
Mailing-List: contact user-help@kylin.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@kylin.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@kylin.apache.org>
List-Post: <mailto:user@kylin.apache.org>
List-Id: <user.kylin.apache.org>
Reply-To: user@kylin.apache.org
Delivered-To: mailing list user@kylin.apache.org
Received: (qmail 27540 invoked by uid 99); 24 Aug 2017 02:44:48 -0000
Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Aug 2017 02:44:48 +0000
Received: from mail-it0-f49.google.com (mail-it0-f49.google.com [209.85.214.49])
	by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 937001A00C5
	for <user@kylin.apache.org>; Thu, 24 Aug 2017 02:44:46 +0000 (UTC)
Received: by mail-it0-f49.google.com with SMTP id 190so8468771itx.0
        for <user@kylin.apache.org>; Wed, 23 Aug 2017 19:44:46 -0700 (PDT)
X-Gm-Message-State: AHYfb5jWsAn9NgtODbFthwX0iaN4b7R3HZgiug7zBPwmsvDQ8nR9w0PU
	E4W/411nQjeh5OBUq773LIRgZF4F6Q==
X-Received: by 10.36.167.73 with SMTP id s9mr5419464iti.45.1503542685659; Wed,
 23 Aug 2017 19:44:45 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.50.25.131 with HTTP; Wed, 23 Aug 2017 19:44:25 -0700 (PDT)
In-Reply-To: <PS1PR03MB1595C77186D3560F5B0ED9F487870@PS1PR03MB1595.apcprd03.prod.outlook.com>
References: <PS1PR03MB1595C77186D3560F5B0ED9F487870@PS1PR03MB1595.apcprd03.prod.outlook.com>
From: Billy Liu <billyliu@apache.org>
Date: Thu, 24 Aug 2017 10:44:25 +0800
X-Gmail-Original-Message-ID: <CABh5zFyGeO3iNfcW-vhZm68h+NHQ16RStFamd9aEnrM+8jdE=g@mail.gmail.com>
Message-ID: <CABh5zFyGeO3iNfcW-vhZm68h+NHQ16RStFamd9aEnrM+8jdE=g@mail.gmail.com>
Subject: Re: where OPS_REGION=lower('Shanghai') ERROR
To: user <user@kylin.apache.org>
Content-Type: multipart/alternative; boundary="f403045fb0dcaf13bc055776cf6d"
archived-at: Thu, 24 Aug 2017 02:44:51 -0000

--f403045fb0dcaf13bc055776cf6d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

What happened if no LOWER function used?

2017-08-21 11:05 GMT+08:00 =E7=A8=8B =E4=B8=87=E8=83=9C <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=3Dlower('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=3Dlower('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=3DLEARN_KYLIN : CUBE[name=3Dkylin_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=3Dkylin_sales_cube] priority 1 c=
ost
> 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=3DSU=
M,
> parameter=3DDEFAULT.KYLIN_SALES.PRICE, returnType=3Dnull] to FunctionDesc
> [expression=3DTOP_N, parameter=3DDEFAULT.KYLIN_SALES.
> PRICE,DEFAULT.KYLIN_SALES.SELLER_ID, returnType=3Dtopn(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.ACCOUN=
T_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=3Dkylin_sales_cube, cuboidId=3D262143, groupsD=3D[DEFAULT.KYLIN_
> CATEGORY_GROUPINGS.META_CATEG_NAME, BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.A=
CCOUNT_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.ACCOUN=
T_COUNTRY,
> BUYER_ACCOUNT:DEFAULT.KYLIN_ACCOUNT.ACCOUNT_COUNTRY, SELLER_COUNTRY:
> DEFAULT.KYLIN_COUNTRY.NAME, BUYER_COUNTRY:DEFAULT.KYLIN_COUNTRY.NAME],
> filterD=3D[DEFAULT.KYLIN_SALES.OPS_REGION], limitPushdown=3D2147483647
> <021%204748%203647>, storageAggr=3Dtrue
> 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=3Dlower('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 :
>
>

--f403045fb0dcaf13bc055776cf6d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">What happened if no LOWER function used?</div><div class=
=3D"gmail_extra"><br><div class=3D"gmail_quote">2017-08-21 11:05 GMT+08:00 =
=E7=A8=8B =E4=B8=87=E8=83=9C <span dir=3D"ltr">&lt;<a href=3D"mailto:chivis=
e.cn@hotmail.com" target=3D"_blank">chivise.cn@hotmail.com</a>&gt;</span>:<=
br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left=
:1px #ccc solid;padding-left:1ex">




<div dir=3D"ltr">
<div id=3D"m_-4995844439108704365divtagdefaultwrapper" style=3D"font-size:1=
2pt;color:#000000;font-family:Calibri,Helvetica,sans-serif" dir=3D"ltr">
<p>hello all:<br>
</p>
<p><br>
</p>
<p>error log:</p>
<p><br>
</p>
<p></p>
<div>2017-08-21 10:26:32,624 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr=
>e3d8e8bfd5d9-82] service.QueryService:366 : Using project: learn_kylin<br>
2017-08-21 10:26:32,625 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] service.QueryService:367 : The original query:=C2=A0 select * =
from KYLIN_SALES where OPS_REGION=3Dlower(&#39;Shanghai&#39;)<br>
2017-08-21 10:26:32,630 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] service.QueryService:493 : The corrected query: select * from =
KYLIN_SALES where OPS_REGION=3Dlower(&#39;Shanghai&#39;)<br>
LIMIT 50000<br>
2017-08-21 10:26:32,632 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] schema.OLAPSchemaFactory:116 : Schema json:{<br>
=C2=A0=C2=A0=C2=A0 &quot;version&quot;: &quot;1.0&quot;,<br>
=C2=A0=C2=A0=C2=A0 &quot;defaultSchema&quot;: &quot;DEFAULT&quot;,<br>
=C2=A0=C2=A0=C2=A0 &quot;schemas&quot;: [<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 {<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;ty=
pe&quot;: &quot;custom&quot;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;na=
me&quot;: &quot;DEFAULT&quot;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;fa=
ctory&quot;: &quot;org.apache.kylin.query.<wbr>schema.OLAPSchemaFactory&quo=
t;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;op=
erand&quot;: {<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 &quot;project&quot;: &quot;LEARN_KYLIN&quot;<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 },<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 &quot;fu=
nctions&quot;: [<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 {<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name: &#39;PERCENTILE&#39;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 className: &#39;org.apache.kylin.measure.=
<wbr>percentile.PercentileAggFunc&#39;<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 },<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 {<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name: &#39;INTERSECT_COUNT&#39;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 className: &#39;org.apache.kylin.measure.=
<wbr>bitmap.<wbr>BitmapIntersectDistinctCountAg<wbr>gFunc&#39;<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 },<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 {<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name: &#39;MASSIN&#39;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 className: &#39;org.apache.kylin.query.ud=
f.<wbr>MassInUDF&#39;<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 },<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 {<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name: &#39;CONCAT&#39;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 className: &#39;org.apache.kylin.query.ud=
f.<wbr>ConcatUDF&#39;<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 },<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 {<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name: &#39;VERSION&#39;,<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 className: &#39;org.apache.kylin.query.ud=
f.<wbr>VersionUDF&#39;<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 }<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ]<br>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 }<br>
=C2=A0=C2=A0=C2=A0 ]<br>
}<br>
2017-08-21 10:26:32,685 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] routing.QueryRouter:56 : Find candidates by table DEFAULT.KYLI=
N_SALES and project=3DLEARN_KYLIN : CUBE[name=3Dkylin_sales_cube]<br>
2017-08-21 10:26:32,686 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] routing.QueryRouter:51 : Applying rule: class org.apache.kylin=
.query.<wbr>routing.rules.<wbr>RemoveBlackoutRealizationsRule<wbr>, realiza=
tions before: [kylin_sales_cube(CUBE)], realizations after:
 [kylin_sales_cube(CUBE)]<br>
2017-08-21 10:26:32,686 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] routing.QueryRouter:51 : Applying rule: class org.apache.kylin=
.query.<wbr>routing.rules.<wbr>RemoveUncapableRealizationsRul<wbr>e, realiz=
ations before: [kylin_sales_cube(CUBE)], realizations after:
 [kylin_sales_cube(CUBE)]<br>
2017-08-21 10:26:32,686 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] rules.RealizationSortRule:40 : CUBE[name=3Dkylin_sales_cube] p=
riority 1 cost 83600.
<br>
2017-08-21 10:26:32,686 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] routing.QueryRouter:51 : Applying rule: class org.apache.kylin=
.query.<wbr>routing.rules.<wbr>RealizationSortRule, realizations before: [k=
ylin_sales_cube(CUBE)], realizations after: [kylin_sales_cube(CUBE)]<br>
2017-08-21 10:26:32,687 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] routing.QueryRouter:68 : The realizations remaining: [kylin_sa=
les_cube(CUBE)] And the final chosen one is the first one<br>
2017-08-21 10:26:32,714 DEBUG [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8e8bfd=
5d9-82] enumerator.OLAPEnumerator:109 : query storage...<br>
2017-08-21 10:26:32,714 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:42 : No group by and aggregation found=
 in this query, will hack some result for better look of output...<br>
2017-08-21 10:26:32,714 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn SELLER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_ID, output will be m=
eaningless.<br>
2017-08-21 10:26:32,715 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn BUYER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_ID, output will be me=
aningless.<br>
2017-08-21 10:26:32,715 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.LEAF_CATEG_ID, output will be me=
aningless.<br>
2017-08-21 10:26:32,715 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.USER_DEFINED_FIELD3, output will=
 be meaningless.<br>
2017-08-21 10:26:32,715 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.USER_DEFINED_FIELD1, output will=
 be meaningless.<br>
2017-08-21 10:26:32,716 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.SITE_ID, output will be meaningl=
ess.<br>
2017-08-21 10:26:32,716 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CAL_DT.CAL_DT, output will be meaningless.<br>
2017-08-21 10:26:32,716 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CAL_DT.MONTH_<wbr>BEG_DT, output will be meaningless.<br=
>
2017-08-21 10:26:32,716 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn SELLER_COUNTRY:DEFAULT.KYLIN_<wbr>COUNTRY.COUNTRY, output will be mean=
ingless.<br>
2017-08-21 10:26:32,717 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn BUYER_COUNTRY:DEFAULT.KYLIN_<wbr>COUNTRY.COUNTRY, output will be meani=
ngless.<br>
2017-08-21 10:26:32,717 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CAL_DT.YEAR_BEG_<wbr>DT, output will be meaningless.<br>
2017-08-21 10:26:32,717 WARN=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] cube.RawQueryLastHacker:73 : SUM is not defined for measure co=
lumn DEFAULT.KYLIN_CAL_DT.WEEK_BEG_<wbr>DT, output will be meaningless.<br>
2017-08-21 10:26:32,717 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] topn.TopNMeasureType:339 : Rewrite function FunctionDesc [expr=
ession=3DSUM, parameter=3DDEFAULT.KYLIN_SALES.<wbr>PRICE, returnType=3Dnull=
] to FunctionDesc [expression=3DTOP_N, parameter=3DDEFAULT.KYLIN_SALES.<wbr=
>PRICE,DEFAULT.KYLIN_SALES.<wbr>SELLER_ID,
 returnType=3Dtopn(100, 6)]<br>
2017-08-21 10:26:32,718 DEBUG [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8e8bfd=
5d9-82] gtrecord.<wbr>GTCubeStorageQueryBase:264 : Need storage aggregation=
<br>
2017-08-21 10:26:32,718 DEBUG [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8e8bfd=
5d9-82] gtrecord.<wbr>GTCubeStorageQueryBase:353 : Storage limit push down =
is impossible because the filter isn&#39;t evaluable<br>
2017-08-21 10:26:32,718 DEBUG [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8e8bfd=
5d9-82] gtrecord.<wbr>GTCubeStorageQueryBase:376 : Storage limit push down =
is impossible because groupD is not clustered at head, groupsD: [DEFAULT.KY=
LIN_CATEGORY_<wbr>GROUPINGS.META_CATEG_NAME, BUYER_ACCOUNT:DEFAULT.KYLIN_<w=
br>ACCOUNT.ACCOUNT_BUYER_LEVEL,
 DEFAULT.KYLIN_SALES.PART_DT, SELLER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACC=
OUNT_SELLER_LEVEL, DEFAULT.KYLIN_SALES.LEAF_<wbr>CATEG_ID, DEFAULT.KYLIN_SA=
LES.LSTG_<wbr>FORMAT_NAME, DEFAULT.KYLIN_SALES.TRANS_ID, DEFAULT.KYLIN_SALE=
S.OPS_USER_<wbr>ID, DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.CATEG_LVL2_NAME,
 DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.CATEG_LVL3_NAME, DEFAULT.KYLIN_SALES=
.LSTG_SITE_<wbr>ID, DEFAULT.KYLIN_SALES.OPS_<wbr>REGION, DEFAULT.KYLIN_SALE=
S.BUYER_ID, SELLER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_COUNTRY, BUYE=
R_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_COUNTRY, SELLER_COUNTRY:<a hre=
f=3D"http://DEFAULT.KYLIN_COUNTRY.NAME" target=3D"_blank">DEFAULT.KYLIN_<wb=
r>COUNTRY.NAME</a>,
 BUYER_COUNTRY:<a href=3D"http://DEFAULT.KYLIN_COUNTRY.NAME" target=3D"_bla=
nk">DEFAULT.KYLIN_<wbr>COUNTRY.NAME</a>] with cuboid columns: [DEFAULT.KYLI=
N_SALES.BUYER_ID, DEFAULT.KYLIN_SALES.SELLER_ID, DEFAULT.KYLIN_SALES.TRANS_=
ID, DEFAULT.KYLIN_SALES.PART_DT, DEFAULT.KYLIN_SALES.LEAF_<wbr>CATEG_ID, DE=
FAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.META_CATEG_NAME,
 DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.CATEG_LVL2_NAME, DEFAULT.KYLIN_CATEG=
ORY_<wbr>GROUPINGS.CATEG_LVL3_NAME, BUYER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUN=
T.ACCOUNT_BUYER_LEVEL, SELLER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_SE=
LLER_LEVEL, BUYER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_COUNTRY,
 SELLER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_COUNTRY, BUYER_COUNTRY:<=
a href=3D"http://DEFAULT.KYLIN_COUNTRY.NAME" target=3D"_blank">DEFAULT.KYLI=
N_<wbr>COUNTRY.NAME</a>, SELLER_COUNTRY:<a href=3D"http://DEFAULT.KYLIN_COU=
NTRY.NAME" target=3D"_blank">DEFAULT.KYLIN_<wbr>COUNTRY.NAME</a>, DEFAULT.K=
YLIN_SALES.LSTG_<wbr>FORMAT_NAME, DEFAULT.KYLIN_SALES.LSTG_SITE_<wbr>ID, DE=
FAULT.KYLIN_SALES.OPS_USER_<wbr>ID, DEFAULT.KYLIN_SALES.OPS_<wbr>REGION]<br=
>
2017-08-21 10:26:32,719 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] gtrecord.<wbr>GTCubeStorageQueryBase:155 : Cuboid identified: =
cube=3Dkylin_sales_cube, cuboidId=3D262143, groupsD=3D[DEFAULT.KYLIN_<wbr>C=
ATEGORY_GROUPINGS.META_CATEG_<wbr>NAME, BUYER_ACCOUNT:DEFAULT.KYLIN_<wbr>AC=
COUNT.ACCOUNT_BUYER_LEVEL,
 DEFAULT.KYLIN_SALES.PART_DT, SELLER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACC=
OUNT_SELLER_LEVEL, DEFAULT.KYLIN_SALES.LEAF_<wbr>CATEG_ID, DEFAULT.KYLIN_SA=
LES.LSTG_<wbr>FORMAT_NAME, DEFAULT.KYLIN_SALES.TRANS_ID, DEFAULT.KYLIN_SALE=
S.OPS_USER_<wbr>ID, DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.CATEG_LVL2_NAME,
 DEFAULT.KYLIN_CATEGORY_<wbr>GROUPINGS.CATEG_LVL3_NAME, DEFAULT.KYLIN_SALES=
.LSTG_SITE_<wbr>ID, DEFAULT.KYLIN_SALES.OPS_<wbr>REGION, DEFAULT.KYLIN_SALE=
S.BUYER_ID, SELLER_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_COUNTRY, BUYE=
R_ACCOUNT:DEFAULT.KYLIN_<wbr>ACCOUNT.ACCOUNT_COUNTRY, SELLER_COUNTRY:<a hre=
f=3D"http://DEFAULT.KYLIN_COUNTRY.NAME" target=3D"_blank">DEFAULT.KYLIN_<wb=
r>COUNTRY.NAME</a>,
 BUYER_COUNTRY:<a href=3D"http://DEFAULT.KYLIN_COUNTRY.NAME" target=3D"_bla=
nk">DEFAULT.KYLIN_<wbr>COUNTRY.NAME</a>], filterD=3D[DEFAULT.KYLIN_SALES.<w=
br>OPS_REGION], limitPushdown=3D<a href=3D"tel:021%204748%203647" value=3D"=
+862147483647" target=3D"_blank">2147483647</a>, storageAggr=3Dtrue<br>
2017-08-21 10:26:32,719 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] gtrecord.CubeSegmentScanner:56 : Init CubeSegmentScanner for s=
egment 20120101000000_20170801010500<br>
2017-08-21 10:26:32,719 ERROR [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8e8bfd=
5d9-82] service.QueryService:421 : Exception when execute sql<br>
java.sql.SQLException: Error while executing SQL &quot;select * from KYLIN_=
SALES where OPS_REGION=3Dlower(&#39;Shanghai&#39;)<br>
LIMIT 50000&quot;: null<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>Helper.createExceptio=
n(Helper.<wbr>java:56)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>Helper.createExceptio=
n(Helper.<wbr>java:41)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>AvaticaStatement.<wbr=
>executeInternal(<wbr>AvaticaStatement.java:156)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>AvaticaStatement.exec=
uteQuery(<wbr>AvaticaStatement.java:218)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.rest.service.<wbr>QueryService.execu=
te(<wbr>QueryService.java:768)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.rest.service.<wbr>QueryService.<wbr>=
queryWithSqlMassage(<wbr>QueryService.java:507)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.rest.service.<wbr>QueryService.query=
(<wbr>QueryService.java:177)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.rest.service.<wbr>QueryService.doQue=
ryWithCache(<wbr>QueryService.java:387)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.rest.<wbr>controller.QueryController=
.<wbr>query(QueryController.java:78)<br>
=C2=A0=C2=A0 =C2=A0at sun.reflect.<wbr>GeneratedMethodAccessor89.<wbr>invok=
e(Unknown Source)<br>
=C2=A0=C2=A0 =C2=A0at sun.reflect.<wbr>DelegatingMethodAccessorImpl.<wbr>in=
voke(<wbr>DelegatingMethodAccessorImpl.<wbr>java:43)<br>
=C2=A0=C2=A0 =C2=A0at java.lang.reflect.Method.<wbr>invoke(Method.java:606)=
<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>method.support.<wbr>Invo=
cableHandlerMethod.<wbr>doInvoke(<wbr>InvocableHandlerMethod.java:<wbr>221)=
<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>method.support.<wbr>Invo=
cableHandlerMethod.<wbr>invokeForRequest(<wbr>InvocableHandlerMethod.java:<=
wbr>136)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.mvc.method.annot=
ation.<wbr>ServletInvocableHandlerMethod.<wbr>invokeAndHandle(<wbr>ServletI=
nvocableHandlerMethod.<wbr>java:110)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.mvc.method.annot=
ation.<wbr>RequestMappingHandlerAdapter.<wbr>invokeHandlerMethod(<wbr>Reque=
stMappingHandlerAdapter.<wbr>java:832)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.mvc.method.annot=
ation.<wbr>RequestMappingHandlerAdapter.<wbr>handleInternal(<wbr>RequestMap=
pingHandlerAdapter.<wbr>java:743)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.mvc.method.<wbr>=
AbstractHandlerMethodAdapter.<wbr>handle(<wbr>AbstractHandlerMethodAdapter.=
<wbr>java:85)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.DispatcherServle=
t.<wbr>doDispatch(DispatcherServlet.<wbr>java:961)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.DispatcherServle=
t.<wbr>doService(DispatcherServlet.<wbr>java:895)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.FrameworkServlet=
.<wbr>processRequest(<wbr>FrameworkServlet.java:967)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.FrameworkServlet=
.<wbr>doPost(FrameworkServlet.java:<wbr>869)<br>
=C2=A0=C2=A0 =C2=A0at javax.servlet.http.<wbr>HttpServlet.service(<wbr>Http=
Servlet.java:650)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>servlet.FrameworkServlet=
.<wbr>service(FrameworkServlet.java:<wbr>843)<br>
=C2=A0=C2=A0 =C2=A0at javax.servlet.http.<wbr>HttpServlet.service(<wbr>Http=
Servlet.java:731)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>internalDoFilter(<wbr>ApplicationFilterChain.java:<wbr>303)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>doFilter(<wbr>ApplicationFilterChain.java:<wbr>208)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.tomcat.websocket.<wbr>server.WsFilter.doFi=
lter(<wbr>WsFilter.java:52)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>internalDoFilter(<wbr>ApplicationFilterChain.java:<wbr>241)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>doFilter(<wbr>ApplicationFilterChain.java:<wbr>208)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:316)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.access.intercep=
t.<wbr>FilterSecurityInterceptor.<wbr>invoke(<wbr>FilterSecurityInterceptor=
.<wbr>java:126)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.access.intercep=
t.<wbr>FilterSecurityInterceptor.<wbr>doFilter(<wbr>FilterSecurityIntercept=
or.<wbr>java:90)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.access.<wbr>Exc=
eptionTranslationFilter.<wbr>doFilter(<wbr>ExceptionTranslationFilter.<wbr>=
java:114)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.session.<wbr>Se=
ssionManagementFilter.<wbr>doFilter(<wbr>SessionManagementFilter.java:<wbr>=
122)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.authentication.=
<wbr>AnonymousAuthenticationFilter.<wbr>doFilter(<wbr>AnonymousAuthenticati=
onFilter.<wbr>java:111)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.servletapi.<wbr=
>SecurityContextHolderAwareRequ<wbr>estFilter.doFilter(<wbr>SecurityContext=
HolderAwareRequ<wbr>estFilter.java:169)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.savedrequest.<w=
br>RequestCacheAwareFilter.<wbr>doFilter(<wbr>RequestCacheAwareFilter.java:=
<wbr>48)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.authentication.=
www.<wbr>BasicAuthenticationFilter.<wbr>doFilterInternal(<wbr>BasicAuthenti=
cationFilter.<wbr>java:213)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>filter.OncePerRequestFil=
ter.<wbr>doFilter(OncePerRequestFilter.<wbr>java:107)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.authentication.=
<wbr>AbstractAuthenticationProcessi<wbr>ngFilter.doFilter(<wbr>AbstractAuth=
enticationProcessi<wbr>ngFilter.java:205)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.authentication.=
logout.<wbr>LogoutFilter.doFilter(<wbr>LogoutFilter.java:120)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.header.HeaderWr=
iterFilter.<wbr>doFilterInternal(<wbr>HeaderWriterFilter.java:64)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>filter.OncePerRequestFil=
ter.<wbr>doFilter(OncePerRequestFilter.<wbr>java:107)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.context.request=
.async.<wbr>WebAsyncManagerIntegrationFilt<wbr>er.doFilterInternal(<wbr>Web=
AsyncManagerIntegrationFilt<wbr>er.java:53)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>filter.OncePerRequestFil=
ter.<wbr>doFilter(OncePerRequestFilter.<wbr>java:107)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.context.<wbr>Se=
curityContextPersistenceFilt<wbr>er.doFilter(<wbr>SecurityContextPersistenc=
eFilt<wbr>er.java:91)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y$<wbr>VirtualFilterChain.doFilter(<wbr>FilterChainProxy.java:330)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y.<wbr>doFilterInternal(<wbr>FilterChainProxy.java:213)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.security.<wbr>web.FilterChainProx=
y.doFilter(<wbr>FilterChainProxy.java:176)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>filter.DelegatingFilterP=
roxy.<wbr>invokeDelegate(<wbr>DelegatingFilterProxy.java:<wbr>346)<br>
=C2=A0=C2=A0 =C2=A0at org.springframework.web.<wbr>filter.DelegatingFilterP=
roxy.<wbr>doFilter(<wbr>DelegatingFilterProxy.java:<wbr>262)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>internalDoFilter(<wbr>ApplicationFilterChain.java:<wbr>241)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>doFilter(<wbr>ApplicationFilterChain.java:<wbr>208)<br>
=C2=A0=C2=A0 =C2=A0at com.thetransactioncompany.<wbr>cors.CORSFilter.doFilt=
er(<wbr>CORSFilter.java:209)<br>
=C2=A0=C2=A0 =C2=A0at com.thetransactioncompany.<wbr>cors.CORSFilter.doFilt=
er(<wbr>CORSFilter.java:244)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>internalDoFilter(<wbr>ApplicationFilterChain.java:<wbr>241)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>ApplicationFilterChain.=
<wbr>doFilter(<wbr>ApplicationFilterChain.java:<wbr>208)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>StandardWrapperValve.in=
voke(<wbr>StandardWrapperValve.java:220)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>StandardContextValve.in=
voke(<wbr>StandardContextValve.java:122)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.<wbr>authenticator.<wbr>Authentic=
atorBase.invoke(<wbr>AuthenticatorBase.java:505)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>StandardHostValve.invok=
e(<wbr>StandardHostValve.java:169)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.valves.<wbr>ErrorReportValve.invo=
ke(<wbr>ErrorReportValve.java:103)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.valves.<wbr>AccessLogValve.invoke=
(<wbr>AccessLogValve.java:956)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.core.<wbr>StandardEngineValve.inv=
oke(<wbr>StandardEngineValve.java:116)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.catalina.connector.<wbr>CoyoteAdapter.serv=
ice(<wbr>CoyoteAdapter.java:436)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.coyote.http11.<wbr>AbstractHttp11Processor=
.<wbr>process(<wbr>AbstractHttp11Processor.java:<wbr>1078)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.coyote.<wbr>AbstractProtocol$<wbr>Abstract=
ConnectionHandler.<wbr>process(AbstractProtocol.java:<wbr>625)<br>
=C2=A0=C2=A0 =C2=A0at <a href=3D"http://org.apache.tomcat.util.net">org.apa=
che.tomcat.util.net</a>.<wbr>JIoEndpoint$SocketProcessor.<wbr>run(JIoEndpoi=
nt.java:316)<br>
=C2=A0=C2=A0 =C2=A0at java.util.concurrent.<wbr>ThreadPoolExecutor.runWorke=
r(<wbr>ThreadPoolExecutor.java:1145)<br>
=C2=A0=C2=A0 =C2=A0at java.util.concurrent.<wbr>ThreadPoolExecutor$Worker.r=
un(<wbr>ThreadPoolExecutor.java:615)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.tomcat.util.<wbr>threads.TaskThread$<wbr>W=
rappingRunnable.run(<wbr>TaskThread.java:61)<br>
=C2=A0=C2=A0 =C2=A0at java.lang.Thread.run(Thread.<wbr>java:745)<br>
Caused by: java.lang.NullPointerException<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.cube.<wbr>CubeSegment.getDictResPath=
(<wbr>CubeSegment.java:299)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.cube.<wbr>CubeManager.getDictionary(=
<wbr>CubeManager.java:269)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.cube.<wbr>CubeSegment.getDictionary(=
<wbr>CubeSegment.java:331)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.cube.kv.<wbr>CubeDimEncMap.getDictio=
nary(<wbr>CubeDimEncMap.java:86)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.dict.<wbr>BuiltInFunctionTransformer=
.<wbr>translateCompareTupleFilter(<wbr>BuiltInFunctionTransformer.<wbr>java=
:130)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.dict.<wbr>BuiltInFunctionTransformer=
.<wbr>transform(<wbr>BuiltInFunctionTransformer.<wbr>java:61)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.storage.<wbr>gtrecord.CubeSegmentSca=
nner.&lt;<wbr>init&gt;(CubeSegmentScanner.java:<wbr>69)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.storage.<wbr>gtrecord.<wbr>GTCubeSto=
rageQueryBase.search(<wbr>GTCubeStorageQueryBase.java:<wbr>88)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.query.<wbr>enumerator.OLAPEnumerator=
.<wbr>queryStorage(OLAPEnumerator.<wbr>java:120)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.kylin.query.<wbr>enumerator.OLAPEnumerator=
.<wbr>moveNext(OLAPEnumerator.java:<wbr>64)<br>
=C2=A0=C2=A0 =C2=A0at Baz$1$1.moveNext(Unknown Source)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.linq4j.<wbr>EnumerableDefaults$<wb=
r>TakeWhileEnumerator.moveNext(<wbr>EnumerableDefaults.java:2952)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.linq4j.<wbr>Linq4j$EnumeratorItera=
tor.&lt;<wbr>init&gt;(Linq4j.java:664)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.linq4j.<wbr>Linq4j.enumeratorItera=
tor(<wbr>Linq4j.java:98)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.linq4j.<wbr>AbstractEnumerable.ite=
rator(<wbr>AbstractEnumerable.java:33)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>MetaImpl.createCursor=
(<wbr>MetaImpl.java:89)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>AvaticaResultSet.exec=
ute(<wbr>AvaticaResultSet.java:196)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.jdbc.<wbr>CalciteResultSet.execute=
(<wbr>CalciteResultSet.java:67)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.jdbc.<wbr>CalciteResultSet.execute=
(<wbr>CalciteResultSet.java:44)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>AvaticaConnection$1.e=
xecute(<wbr>AvaticaConnection.java:607)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.jdbc.<wbr>CalciteMetaImpl.<wbr>pre=
pareAndExecute(<wbr>CalciteMetaImpl.java:600)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>AvaticaConnection.<wb=
r>prepareAndExecuteInternal(<wbr>AvaticaConnection.java:615)<br>
=C2=A0=C2=A0 =C2=A0at org.apache.calcite.avatica.<wbr>AvaticaStatement.<wbr=
>executeInternal(<wbr>AvaticaStatement.java:148)<br>
=C2=A0=C2=A0 =C2=A0... 81 more<br>
2017-08-21 10:26:32,720 INFO=C2=A0 [Query 4bb70ccb-68e7-4b11-965f-<wbr>e3d8=
e8bfd5d9-82] service.QueryService:284 :=C2=A0</div>
<br>
<p></p>
</div>
</div>

</blockquote></div><br></div>

--f403045fb0dcaf13bc055776cf6d--