[
https://issues.apache.org/jira/browse/KYLIN-5152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hujiahua updated KYLIN-5152:
----------------------------
Description:
Current the following SQL will fail because true expressions was not supportted
on where clause.
{code:java}
select SELLER_ID,sum(PRICE) from KYLIN_SALES where TURE and PART_DT =
'2012-01-01' GROUP BY SELLER_ID {code}
In some case, calcite will converts the filter expression of the where clause
into a true expression. So I think we better support this.
was:
Current the following SQL will fail because true expressions was not supportted
on where clause.
{code:java}
select SELLER_ID,sum(PRICE) from KYLIN_SALES where TURE and PART_DT =
'2012-01-01' GROUP BY SELLER_ID {code}
In some case, calcite will converts the filter expression of the where clause
into a true expression. So I think we better support this.
> Support boolean expression on where clause
> -------------------------------------------
>
> Key: KYLIN-5152
> URL: https://issues.apache.org/jira/browse/KYLIN-5152
> Project: Kylin
> Issue Type: Improvement
> Components: Query Engine
> Affects Versions: v4.0.1
> Reporter: hujiahua
> Priority: Minor
>
> Current the following SQL will fail because true expressions was not
> supportted on where clause.
> {code:java}
> select SELLER_ID,sum(PRICE) from KYLIN_SALES where TURE and PART_DT =
> '2012-01-01' GROUP BY SELLER_ID {code}
> In some case, calcite will converts the filter expression of the where clause
> into a true expression. So I think we better support this.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
