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