hive脚本中NOT EXISTS改为左连接left join

Question

如题：
SELECT A.*, ERROR_TWO_TYPE
FROM SRBZ_HIVE.TMP_YWJH_ZQZRR_DW_02 A
WHERE NOT EXISTS (SELECT 1
FROM DIC_INT.INT_ODS_USER_AGENT_INFO_D T
WHERE A.PROD_INST_ID = T.PROD_INST_ID)

Answer 1

SELECT A.*, ERROR_TWO_TYPE
FROM SRBZ_HIVE.TMP_YWJH_ZQZRR_DW_02 A
left join DIC_INT.INT_ODS_USER_AGENT_INFO_D T
on A.PROD_INST_ID = T.PROD_INST_ID
where T.PROD_INST_ID is null