row-wise IN would be useful --------------------------- Key: HIVE-801 URL: https://issues.apache.org/jira/browse/HIVE-801 Project: Hadoop Hive Issue Type: New Feature Reporter: Adam Kramer
SELECT * FROM tablename t WHERE IN(12345,key1,key2,key3); ...IN would operate on a given row, and return True when the first argument equaled at least one of the other arguments. So here IN would return true if 12345=key1 OR 12345=key2 OR 12345=key3 (but wouldn't test the latter two if the first matched). This would also help with https://issues.apache.org/jira/browse/HIVE-783, if IN were implemented in a manner that allows it to be used in an ON clause. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.