kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Na Zhai <na.z...@kyligence.io>
Subject 答复: [kylin] left join怎样join is null记录
Date Sun, 17 Feb 2019 12:57:59 GMT
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 <jeific@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:chenyj@outlook.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message