You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by "Alex.Wang" <al...@gmail.com> on 2012/12/24 08:32:10 UTC

Does Hive support the standard IN and EXIST query?

Hi everyone.
After read through the HiveQL manual, I have no luck in finding the
corresponding statement for IN and EXIST query.
Can anyone tell me whether Hive supports the standard SQL IN and EXIST
query?

Thank you very much for any help or hint. :D


Best regards.

Re: Does Hive support the standard IN and EXIST query?

Posted by Nitin Pawar <ni...@gmail.com>.

hive does support IN clause in where (
https://issues.apache.org/jira/browse/HIVE-801)

LEFT SEMI JOIN implements the correlated IN/EXISTS subquery(more on this is
in http://hive.apache.org/docs/r0.9.0/language_manual/joins.html)



On Mon, Dec 24, 2012 at 1:02 PM, Alex.Wang <al...@gmail.com> wrote:

> Hi everyone.
> After read through the HiveQL manual, I have no luck in finding the
> corresponding statement for IN and EXIST query.
> Can anyone tell me whether Hive supports the standard SQL IN and EXIST
> query?
>
> Thank you very much for any help or hint. :D
>
>
> Best regards.
>



-- 
Nitin Pawar