You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Zhong Yanghong (JIRA)" <ji...@apache.org> on 2019/01/29 10:27:00 UTC
[jira] [Updated] (KYLIN-3794) mergeToInClause in TupleFilterVisitor
cannot work properly in some edge cases
[ https://issues.apache.org/jira/browse/KYLIN-3794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhong Yanghong updated KYLIN-3794:
----------------------------------
Description:
There are two cases that mergeToInClause() does not work properly:
{code}
select count(*)
from TEST_KYLIN_FACT
where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or DEAL_YEAR in (2012, 2013)
{code}
{code}
select count(*)
from TEST_KYLIN_FACT
where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or LSTG_FORMAT_NAME not in ('Auction', 'Others')
{code}
was:
There are two cases that mergeToInClause() does not work properly:
{code}
select count(*)
from TEST_KYLIN_FACT
where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or DEAL_YEAR not in (2012, 2013)
{code}
{code}
select count(*)
from TEST_KYLIN_FACT
where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or LSTG_FORMAT_NAME not in ('Auction', 'Others')
{code}
> mergeToInClause in TupleFilterVisitor cannot work properly in some edge cases
> -----------------------------------------------------------------------------
>
> Key: KYLIN-3794
> URL: https://issues.apache.org/jira/browse/KYLIN-3794
> Project: Kylin
> Issue Type: Improvement
> Reporter: Zhong Yanghong
> Assignee: Zhong Yanghong
> Priority: Major
>
> There are two cases that mergeToInClause() does not work properly:
> {code}
> select count(*)
> from TEST_KYLIN_FACT
> where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or DEAL_YEAR in (2012, 2013)
> {code}
> {code}
> select count(*)
> from TEST_KYLIN_FACT
> where LSTG_FORMAT_NAME in ('ABIN', 'Auction') or LSTG_FORMAT_NAME not in ('Auction', 'Others')
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)