Re: Unexpected behavior when joinning streaming table and hive table

Thank you for your reply, the gist contains the corresponding model description json file. But not list together with cube. I have updated the gist with timestamp column renamed to epoch to avoid the syntax error during query. But this problem still reproduced. Lifan Su -- Sent from:

[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