[ https://issues.apache.org/jira/browse/KYLIN-2173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15678999#comment-15678999 ]
Dayue Gao commented on KYLIN-2173: ---------------------------------- BTW, could we build a shared CI infrastructure? Running IT in my local sandbox is super slow. > push down limit leads to wrong answer when filter is loosened > ------------------------------------------------------------- > > Key: KYLIN-2173 > URL: https://issues.apache.org/jira/browse/KYLIN-2173 > Project: Kylin > Issue Type: Bug > Components: Storage - HBase > Affects Versions: v1.5.4.1 > Reporter: Dayue Gao > Assignee: Dayue Gao > Fix For: v1.6.0 > > > To reproduce: > {noformat} > select > test_kylin_fact.cal_dt > ,sum(test_kylin_fact.price) as GMV > FROM test_kylin_fact > left JOIN edw.test_cal_dt as test_cal_dt > ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt > where test_cal_dt.week_beg_dt in ('2012-01-01', '2012-01-20') > group by test_kylin_fact.cal_dt > limit 12 > {noformat} > Kylin returns 5 rows, expect 12 rows. > Root cause: filter condition may be loosened when we translate derived filter > in DerivedFilterTranslator. If we push down limit, query server won't get > enough valid records from storage. In the above example, 24 rows returned > from storage, only 5 are valid. -- This message was sent by Atlassian JIRA (v6.3.4#6332)