Hi, chen I can not see your picture, you can try to add these in the attachment. Does it have any error message? Maybe you can try to change null to another word, like “unknown”.
Best wishes! 发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用 ________________________________ 发件人: chen snowlake <jei...@outlook.com> 发送时间: Thursday, February 14, 2019 6:07:01 PM 收件人: dev@kylin.apache.org 主题: [kylin] left join怎样join is null记录 HI: 大家好,在join的时候,我的联合的条件数据中存在is null记录,他们不能join起来 请问kylin是怎么写这样的查询? 不胜感激 比如 [cid:image003.png@01D4C490.0483D3B0] … left Join … on ((a.region = a0.region) or (a.region is null and a0.region is null )) 这样的条件并不能将 nul行join起来 [cid:image006.png@01D4C490.0483D3B0] SnowLake Email:che...@outlook.com