hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <>
Subject [jira] Created: (HIVE-801) row-wise IN would be useful
Date Wed, 26 Aug 2009 20:55:59 GMT
row-wise IN would be useful

                 Key: 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, 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.

View raw message