Yup, sub-queries don't work in the where clause.
Is there another document and/or JIRA that i can look at for the
implementation of IN clause?
Regards,
--
Rohan Monga
On Mon, Dec 12, 2011 at 10:19 PM, Igor Tatarinov i...@decide.com wrote:
I think the doc refers to an IN subquery
WHERE x IN
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
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