Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Does Hive support the standard IN and EXIST query?


Copy link to this message
-
Re: Does Hive support the standard IN and EXIST query?
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