-Re: Confusion about IN clause
Igor Tatarinov 2011-12-13, 06:19
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:
On Mon, Dec 12, 2011 at 10:09 PM, rohan monga <[EMAIL PROTECTED]> wrote:
> I though that 'IN' clause was not supported by hive ( version 0.7 )
> according to the documentation
> but a friend of mine showed me that queries like the following
> select * from table where row in (1,2,3);
> 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?
> Rohan Monga