WHERE子句中的HIVE SQL子查询 [英] HIVE SQL Subquery in WHERE Clause

问题描述

我有两个具有相似字段的表，但是当我在 WHERE 子句中执行 SELECT 子查询时，查询失败.

I have two tables with similar fields but the query is failing when I am doing a SELECT subquery in a WHERE clause.

SELECT foo 
FROM   bar
WHERE  fizz IN (SELECT fizz FROM fuzz)

我从AWS删除了 error.log ，但该错误在一定程度上使HIVE无法识别 SELECT .

I deleted the error.log from AWS but the error was something to the extent that HIVE did not recognize the SELECT.

我该如何重组该查询?

谢谢.

推荐答案

来自 HIVE语言手册:

SELECT b.foo FROM bar b WHERE b.fizz IN (SELECT f.fizz FROM fuzz f)

这篇关于WHERE子句中的HIVE SQL子查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！