[
https://issues.apache.org/jira/browse/KYLIN-3403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16524673#comment-16524673
]
ASF GitHub Bot commented on KYLIN-3403:
---------------------------------------
Wayne1c opened a new pull request #159: KYLIN-3403 filter code system add one
type of Date
URL: https://github.com/apache/kylin/pull/159
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> Querying sample cube with filter "KYLIN_CAL_DT.WEEK_BEG_DT >=
> CAST('2001-09-09' AS DATE)" returns unexpected empty result set
> ------------------------------------------------------------------------------------------------------------------------------
>
> 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.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=learn_kylin :
> INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_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.routing.rules.RemoveBlackoutRealizationsRule,
> realizations before:
> [INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]],
> realizations after:
> [INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_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.routing.rules.RemoveUncapableRealizationsRule,
> realizations before:
> [INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]],
> realizations after:
> [INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]]
> 2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
> rules.RealizationSortRule : INVERTED_INDEX[name=kylin_sales_cube] priority 1
> cost 8360. CUBE[name=kylin_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.routing.rules.RealizationSortRule, realizations
> before: [INVERTED_INDEX[name=kylin_sales_cube],CUBE[name=kylin_sales_cube]],
> realizations after:
> [CUBE[name=kylin_sales_cube],INVERTED_INDEX[name=kylin_sales_cube]]
> 2018-05-16 13:30:17,844 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
> routing.QueryRouter : The realizations remaining:
> [CUBE[name=kylin_sales_cube],INVERTED_INDEX[name=kylin_sales_cube]],and the
> final chosen one for current olap context 0 is CUBE[name=kylin_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 need
> storage aggregation
> 2018-05-16 13:30:18,091 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
> lookup.SnapshotManager : Loading snapshotTable from
> /table_snapshot/DEFAULT.KYLIN_CAL_DT/2d3d125a-30f7-438f-bede-7212c5666f4a.snapshot,
> with loadData: true
> 2018-05-16 13:30:18,197 DEBUG [Query
> aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162] lookup.SnapshotManager : Loaded
> snapshot at
> /table_snapshot/DEFAULT.KYLIN_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 because derived column require post
> aggregation: [DEFAULT.KYLIN_SALES.PART_DT]
> 2018-05-16 13:30:18,426 DEBUG [Query
> aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162] gtrecord.GTCubeStorageQueryBase :
> storageLimitLevel set to NO_LIMIT because 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=kylin_sales_cube,
> cuboidId=16384, groupsD=[], filterD=[], limitPushdown=2147483647,
> limitLevel=NO_LIMIT, storageAggr=true
> 2018-05-16 13:30:18,429 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
> gtrecord.CubeSegmentScanner : Init CubeSegmentScanner for segment
> 20120101000000_20180403152544
> 2018-05-16 13:30:18,476 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
> gtrecord.ScannerWorker : Segment
> kylin_sales_cube[20120101000000_20180403152544] 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, duration:
> 2711, total scan count 0
> 2018-05-16 13:30:18,512 INFO [Query aa20e5fd-8b86-4359-a87a-2a2e7b8c100a-162]
> service.QueryService :
> ==========================[QUERY]===============================
> 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 =
> KYLIN_CAL_DT.CAL_DT
> JOIN "DEFAULT"."KYLIN_CATEGORY_GROUPINGS" AS "KYLIN_CATEGORY_GROUPINGS" ON
> KYLIN_SALES.LEAF_CATEG_ID = KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID
> AND KYLIN_SALES.LSTG_SITE_ID = KYLIN_CATEGORY_GROUPINGS.SITE_ID
> JOIN "DEFAULT"."KYLIN_ACCOUNT" AS "BUYER_ACCOUNT" ON KYLIN_SALES.BUYER_ID =
> BUYER_ACCOUNT.ACCOUNT_ID
> JOIN "DEFAULT"."KYLIN_ACCOUNT" AS "SELLER_ACCOUNT" ON KYLIN_SALES.SELLER_ID =
> SELLER_ACCOUNT.ACCOUNT_ID
> JOIN "DEFAULT"."KYLIN_COUNTRY" AS "BUYER_COUNTRY" ON
> BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY
> JOIN "DEFAULT"."KYLIN_COUNTRY" AS "SELLER_COUNTRY" ON
> SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY
> WHERE KYLIN_CAL_DT.WEEK_BEG_DT >= 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=kylin_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
> ==========================[QUERY]===============================
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
