You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "hujiahua (Jira)" <ji...@apache.org> on 2022/01/10 11:52:00 UTC

[jira] [Created] (KYLIN-5152) Support boolean expression on where clause

hujiahua created KYLIN-5152:
-------------------------------

             Summary: 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


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)