[
https://issues.apache.org/jira/browse/KYLIN-5542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Laura Xia updated KYLIN-5542:
-----------------------------
Attachment: image-2023-06-05-11-19-16-559.png
> 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
> Priority: Critical
> Attachments: image-2023-06-05-11-18-42-981.png,
> image-2023-06-05-11-19-01-793.png, image-2023-06-05-11-19-16-559.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)
