hive> select a.waybill_no,
> a.orig_cty_code,
> a.dest_cty_code,
> a.product_code,
> b.rule_code
> from test1 a
> left join test2 b
> on a.product_code = b.product_code
> and (b.orig_cty_code is null or a.orig_cty_code = b.orig_cty_code);
FAILED: SemanticException Line 0:-1 OR not supported in JOIN currently 'orig_cty_code'
HIVE中left join on后面不能跟OR吗,有什么办法可以达到同样效果吗?
- 写回答
- 好问题 0 提建议
- 关注问题
- 邀请回答
-