在字段前加上表别名
select report_time from tmp.test_1030_external_dt t1 where report_time not in ( select report_time from tmp.test_1031_external_dt );
--FAILED: SemanticException Column report_time Found in more than One Tables/Subqueries
select t1.report_time from tmp.test_1030_external_dt t1 where t1.report_time not in ( select report_time from tmp.test_1031_external_dt );
-- 正确
Hive 2.0.0
