From issues-return-18408-archive-asf-public=cust-asf.ponee.io@kylin.apache.org Wed Jun 27 12:35:05 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 273D018066B for ; Wed, 27 Jun 2018 12:35:04 +0200 (CEST) Received: (qmail 18733 invoked by uid 500); 27 Jun 2018 10:35:04 -0000 Mailing-List: contact issues-help@kylin.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@kylin.apache.org Delivered-To: mailing list issues@kylin.apache.org Received: (qmail 18713 invoked by uid 99); 27 Jun 2018 10:35:04 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Jun 2018 10:35:04 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 8EAFFC0157 for ; Wed, 27 Jun 2018 10:35:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.501 X-Spam-Level: X-Spam-Status: No, score=-109.501 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id Qk1gKhsS3eP6 for ; Wed, 27 Jun 2018 10:35:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id AA8AF5F35A for ; Wed, 27 Jun 2018 10:35:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 3141AE015A for ; Wed, 27 Jun 2018 10:35:01 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id E0E7F23F96 for ; Wed, 27 Jun 2018 10:35:00 +0000 (UTC) Date: Wed, 27 Jun 2018 10:35:00 +0000 (UTC) From: "Shaofeng SHI (JIRA)" To: issues@kylin.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (KYLIN-3403) Querying sample cube with filter "KYLIN_CAL_DT.WEEK_BEG_DT >= CAST('2001-09-09' AS DATE)" returns unexpected empty result set MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/KYLIN-3403?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] Shaofeng SHI reassigned KYLIN-3403: ----------------------------------- Assignee: Yifan Zhang (was: Chao Long) Yifan already works on this, and he=C2=A0has added some test case. Wait for= his patch. > Querying sample cube with filter "KYLIN_CAL_DT.WEEK_BEG_DT >=3D CAST('200= 1-09-09' AS DATE)" returns unexpected empty result set=20 > -------------------------------------------------------------------------= ----------------------------------------------------- > > Key: KYLIN-3403 > URL: https://issues.apache.org/jira/browse/KYLIN-3403 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Reporter: Yifan Zhang > Assignee: Yifan Zhang > Priority: Major > Fix For: v2.4.1, v2.5.0 > > > 2018-05-16 13:30:17,824 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a= -162] cachesync.CachedCrudAssist : Loaded 3 ColumnACL(s) out of 3 resource > 2018-05-16 13:30:17,840 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] routing.QueryRouter : Find candidates by table DEFAULT.KYLIN_SALES and= project=3Dlearn_kylin : INVERTED_INDEX[name=3Dkylin_sales_cube],CUBE[name= =3Dkylin_sales_cube] > 2018-05-16 13:30:17,841 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] routing.QueryRouter : Applying rule: class org.apache.kylin.query.rout= ing.rules.RemoveBlackoutRealizationsRule, realizations before: [INVERTED_IN= DEX[name=3Dkylin_sales_cube],CUBE[name=3Dkylin_sales_cube]], realizations a= fter: [INVERTED_INDEX[name=3Dkylin_sales_cube],CUBE[name=3Dkylin_sales_cube= ]] > 2018-05-16 13:30:17,843 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] routing.QueryRouter : Applying rule: class org.apache.kylin.query.rout= ing.rules.RemoveUncapableRealizationsRule, realizations before: [INVERTED_I= NDEX[name=3Dkylin_sales_cube],CUBE[name=3Dkylin_sales_cube]], realizations = after: [INVERTED_INDEX[name=3Dkylin_sales_cube],CUBE[name=3Dkylin_sales_cub= e]] > 2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] rules.RealizationSortRule : INVERTED_INDEX[name=3Dkylin_sales_cube] pr= iority 1 cost 8360. CUBE[name=3Dkylin_sales_cube] priority 1 cost 836. > 2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] routing.QueryRouter : Applying rule: class org.apache.kylin.query.rout= ing.rules.RealizationSortRule, realizations before: [INVERTED_INDEX[name=3D= kylin_sales_cube],CUBE[name=3Dkylin_sales_cube]], realizations after: [CUBE= [name=3Dkylin_sales_cube],INVERTED_INDEX[name=3Dkylin_sales_cube]] > 2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] routing.QueryRouter : The realizations remaining: [CUBE[name=3Dkylin_s= ales_cube],INVERTED_INDEX[name=3Dkylin_sales_cube]],and the final chosen on= e for current olap context 0 is CUBE[name=3Dkylin_sales_cube] > 2018-05-16 13:30:18,042 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a= -162] enumerator.OLAPEnumerator : query storage... > 2018-05-16 13:30:18,082 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a= -162] gtrecord.GTCubeStorageQueryBase : Need storage aggregation > 2018-05-16 13:30:18,083 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] gtrecord.GTCubeStorageQueryBase : exactAggregation is false because ne= ed storage aggregation > 2018-05-16 13:30:18,091 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] lookup.SnapshotManager : Loading snapshotTable from /table_snapshot/DE= FAULT.KYLIN_CAL_DT/2d3d125a-30f7-438f-bede-7212c5666f4a.snapshot, with load= Data: true > 2018-05-16 13:30:18,197 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a= -162] lookup.SnapshotManager : Loaded snapshot at /table_snapshot/DEFAULT.K= YLIN_CAL_DT/2d3d125a-30f7-438f-bede-7212c5666f4a.snapshot > 2018-05-16 13:30:18,426 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] gtrecord.GTCubeStorageQueryBase : Filter column set for query: [] > 2018-05-16 13:30:18,426 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] gtrecord.GTCubeStorageQueryBase : Filter mask is: 0 > 2018-05-16 13:30:18,426 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a= -162] gtrecord.GTCubeStorageQueryBase : storageLimitLevel set to NO_LIMIT b= ecause derived column require post aggregation: [DEFAULT.KYLIN_SALES.PART_D= T] > 2018-05-16 13:30:18,426 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a= -162] gtrecord.GTCubeStorageQueryBase : storageLimitLevel set to NO_LIMIT b= ecause the query has order by > 2018-05-16 13:30:18,427 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] gtrecord.GTCubeStorageQueryBase : Cuboid identified: cube=3Dkylin_sale= s_cube, cuboidId=3D16384, groupsD=3D[], filterD=3D[], limitPushdown=3D21474= 83647, limitLevel=3DNO_LIMIT, storageAggr=3Dtrue > 2018-05-16 13:30:18,429 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] gtrecord.CubeSegmentScanner : Init CubeSegmentScanner for segment 2012= 0101000000_20180403152544 > 2018-05-16 13:30:18,476 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] gtrecord.ScannerWorker : Segment kylin_sales_cube[20120101000000_20180= 403152544] will be skipped > 2018-05-16 13:30:18,477 DEBUG [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a= -162] enumerator.OLAPEnumerator : return TupleIterator... > 2018-05-16 13:30:18,481 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] service.QueryService : Processed rows for each storageContext: 0 > 2018-05-16 13:30:18,481 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] service.QueryService : Stats of SQL response: isException: false, dura= tion: 2711, total scan count 0 > 2018-05-16 13:30:18,512 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-= 162] service.QueryService : > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D[QUERY]=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Query Id: aa20e5fd-8b86-4359-a87a-2a2e7b8c100a > SQL: SELECT COUNT(1) AS "TRANS_CNT" > FROM "DEFAULT"."KYLIN_SALES" AS "KYLIN_SALES" > JOIN "DEFAULT"."KYLIN_CAL_DT" AS "KYLIN_CAL_DT" ON KYLIN_SALES.PART_DT = =3D KYLIN_CAL_DT.CAL_DT > JOIN "DEFAULT"."KYLIN_CATEGORY_GROUPINGS" AS "KYLIN_CATEGORY_GROUPINGS" O= N KYLIN_SALES.LEAF_CATEG_ID =3D KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID > AND KYLIN_SALES.LSTG_SITE_ID =3D KYLIN_CATEGORY_GROUPINGS.SITE_ID > JOIN "DEFAULT"."KYLIN_ACCOUNT" AS "BUYER_ACCOUNT" ON KYLIN_SALES.BUYER_ID= =3D BUYER_ACCOUNT.ACCOUNT_ID > JOIN "DEFAULT"."KYLIN_ACCOUNT" AS "SELLER_ACCOUNT" ON KYLIN_SALES.SELLER_= ID =3D SELLER_ACCOUNT.ACCOUNT_ID > JOIN "DEFAULT"."KYLIN_COUNTRY" AS "BUYER_COUNTRY" ON BUYER_ACCOUNT.ACCOUN= T_COUNTRY =3D BUYER_COUNTRY.COUNTRY > JOIN "DEFAULT"."KYLIN_COUNTRY" AS "SELLER_COUNTRY" ON SELLER_ACCOUNT.ACCO= UNT_COUNTRY =3D SELLER_COUNTRY.COUNTRY > WHERE KYLIN_CAL_DT.WEEK_BEG_DT >=3D date'2001-09-05' > ORDER BY "TRANS_CNT" ASC > LIMIT 10000 > User: ADMIN > Success: true > Duration: 2.742 > Project: learn_kylin > Realization Names: [CUBE[name=3Dkylin_sales_cube]] > Cuboid Ids: [16384] > Total scan count: 0 > Total scan bytes: 0 > Result row count: 1 > Accept Partial: true > Is Partial Result: false > Hit Exception Cache: false > Storage cache used: false > Is Query Push-Down: false > Is Prepare: false > Trace URL: null > Message: null > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D[QUERY]=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D -- This message was sent by Atlassian JIRA (v7.6.3#76005)