WHERE NOT EXISTS(SELECT 1 FROM JKS_FDS.T_BI_CRYSTAL_DELETE_ITEM P WHERE T.FACTORY=P.FACTORY
AND T.ITEM=P.ITEM_CODE)
这种not exists 写法hive不支持,可以改为
WHERE T.FACTORY
NOT in(
SELECT
P.FACTORY
FROM
stg_BI_CRYSTAL_DELETE_ITEM P
WHERE
T.FACTORY = P.FACTORY AND T.HKONT = P.ITEM_CODE)
网上说的改为left join 的方式,有些过于复杂,且当not exists较多时,转换很麻烦