hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Tatarinov <i...@decide.com>
Subject Re: Confusion about IN clause
Date Tue, 13 Dec 2011 06:19:08 GMT
I think the doc refers to an IN subquery
WHERE x IN (SELECT blah FROM ...)

the simple WHERE col IN ('x', 'y', 'z') works fine.

I  imagine none of these work:
http://www.dba-oracle.com/sql/t_subquery_not_in_exists.htm


igor
decide.com

On Mon, Dec 12, 2011 at 10:09 PM, rohan monga <monga.rohan@gmail.com> wrote:

> Hi,
> I though that 'IN' clause was not supported by hive ( version 0.7 )
> according to the documentation
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-WHEREClause
>
> but a friend of mine showed me that queries like the following
> <snip>
> select * from table where row in (1,2,3);
> </snip>
> work. and I found this JIRA https://issues.apache.org/jira/browse/HIVE-801which kinda
shows that it should work.
>
> Was this feature deprecated in the later version ( 0.7.1) or is the
> documentation out of sync?
>
> Thanks,
> --
> Rohan Monga
>

Mime
View raw message