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.

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 <[EMAIL PROTECTED]> 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