情景
在验证sql ,发现没有写错,oracle和hive 条数也是一样的,但是整列都为null,我就猜是不是两个数据库的格式的问题
trim() 修剪
trim(字段名)
sql示例
oracle 原sql
select
(select b.code
from B b
where b.code = a.type
and b.codetype) = 'sc') as Type,
from
A a
hive 改sql
select
b.tar as Type,
from
A a
LEFT JOIN
B b
on b.code = a.type
and trim(b.codetype) = 'sc'