Laura Xia created KYLIN-5542:
--------------------------------
Summary: Add Segment is advised when the query is out of service
range in query condition mutex.
Key: KYLIN-5542
URL: https://issues.apache.org/jira/browse/KYLIN-5542
Project: Kylin
Issue Type: Bug
Reporter: Laura Xia
Attachments: image-2023-06-05-11-18-42-981.png
查询中条件互斥，CUSTOMER.C_NATION in ('INDONESIA') and CUSTOMER.C_NATION in ('KENYA')，
聚合查询返回结果为空，如图
!image-2023-06-05-11-16-07-206.png!
{code:java}
SELECT count(*) as cnt FROM SSB.LINEORDER as LINEORDER INNER JOIN SSB.CUSTOMER
as CUSTOMER ON LINEORDER.LO_CUSTKEY=CUSTOMER.C_CUSTKEY WHERE 1 = 1 and
LO_ORDERDATE = '1993-01-02' and CUSTOMER.C_NATION in ('INDONESIA') and
CUSTOMER.C_NATION in ('KENYA') ;
{code}
当修改SQL后，可正常返回结果为0， 如图：
!image-2023-06-05-11-17-17-824.png!
模型中对应1993-01-02的segment是存在的：
!image-2023-06-05-11-17-47-346.png!
WHERE条件互斥时: 聚合查询如sum、max、min等应当返回null 聚合查询如count，count distinct 等应当返回0
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
