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)