kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-3403) Querying sample cube with filter "KYLIN_CAL_DT.WEEK_BEG_DT >= CAST('2001-09-09' AS DATE)" returns unexpected empty result set
Date Wed, 27 Jun 2018 07:20:00 GMT

    [ https://issues.apache.org/jira/browse/KYLIN-3403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16524694#comment-16524694
] 

ASF GitHub Bot commented on KYLIN-3403:
---------------------------------------

codecov-io commented on issue #159: KYLIN-3403 filter code system add one type of Date
URL: https://github.com/apache/kylin/pull/159#issuecomment-400568741
 
 
   # [Codecov](https://codecov.io/gh/apache/kylin/pull/159?src=pr&el=h1) Report
   > Merging [#159](https://codecov.io/gh/apache/kylin/pull/159?src=pr&el=desc) into
[master](https://codecov.io/gh/apache/kylin/commit/a0595c07ebfcade52f10e9ac134fa3e330fc57da?src=pr&el=desc)
will **decrease** coverage by `<.01%`.
   > The diff coverage is `0%`.
   
   [![Impacted file tree graph](https://codecov.io/gh/apache/kylin/pull/159/graphs/tree.svg?token=JawVgbgsVo&src=pr&height=150&width=650)](https://codecov.io/gh/apache/kylin/pull/159?src=pr&el=tree)
   
   ```diff
   @@             Coverage Diff              @@
   ##             master     #159      +/-   ##
   ============================================
   - Coverage     22.44%   22.44%   -0.01%     
     Complexity     4155     4155              
   ============================================
     Files          1034     1034              
     Lines         62179    62191      +12     
     Branches       8907     8909       +2     
   ============================================
   + Hits          13957    13958       +1     
   - Misses        46902    46913      +11     
     Partials       1320     1320
   ```
   
   
   | [Impacted Files](https://codecov.io/gh/apache/kylin/pull/159?src=pr&el=tree) | Coverage
Δ | Complexity Δ | |
   |---|---|---|---|
   | [...kylin/metadata/filter/FilterCodeSystemFactory.java](https://codecov.io/gh/apache/kylin/pull/159/diff?src=pr&el=tree#diff-Y29yZS1tZXRhZGF0YS9zcmMvbWFpbi9qYXZhL29yZy9hcGFjaGUva3lsaW4vbWV0YWRhdGEvZmlsdGVyL0ZpbHRlckNvZGVTeXN0ZW1GYWN0b3J5LmphdmE=)
| `0% <0%> (ø)` | `0 <0> (ø)` | :arrow_down: |
   | [...rg/apache/kylin/cube/inmemcubing/MemDiskStore.java](https://codecov.io/gh/apache/kylin/pull/159/diff?src=pr&el=tree#diff-Y29yZS1jdWJlL3NyYy9tYWluL2phdmEvb3JnL2FwYWNoZS9reWxpbi9jdWJlL2lubWVtY3ViaW5nL01lbURpc2tTdG9yZS5qYXZh)
| `69.6% <0%> (+0.3%)` | `7% <0%> (ø)` | :arrow_down: |
   
   ------
   
   [Continue to review full report at Codecov](https://codecov.io/gh/apache/kylin/pull/159?src=pr&el=continue).
   > **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta)
   > `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`
   > Powered by [Codecov](https://codecov.io/gh/apache/kylin/pull/159?src=pr&el=footer).
Last update [a0595c0...3a192d5](https://codecov.io/gh/apache/kylin/pull/159?src=pr&el=lastupdated).
Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).
   

----------------------------------------------------------------
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:
users@infra.apache.org


> 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)

Mime
View raw message