Hive FAILED: SemanticException Column report_time Found in more than One Tables/Subqueries

清疚 2021-09-24 15:30 263阅读 0赞

在字段前加上表别名

  1. select report_time from tmp.test_1030_external_dt t1 where report_time not in ( select report_time from tmp.test_1031_external_dt );
  2. --FAILED: SemanticException Column report_time Found in more than One Tables/Subqueries
  3. 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 );
  4. -- 正确

Hive 2.0.0

发表评论

表情:
评论列表 (有 0 条评论,263人围观)

还没有评论,来说两句吧...

相关阅读