hive-sql查询，在从另一个子选择查询获得的值之间选择var

Question

我想做这个

select x,y,z from table1 where x between (select a from table2) and (select b from table2);

这可能吗？如果是，如何？

Answer 1

您可以使用exists:

select t1.x, t1.y, t1.z
from table1 t1
where exists (select 1
from table2 t2
where t1.x between t2.a and t2.b
);