SELECT * FROM tablename t
...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.
|Status||Resolved [ 5 ]||Closed [ 6 ]|
|Affects Version/s||0.5.0 [ 12314156 ]|
|Affects Version/s||0.4.1 [ 12314225 ]|
|Affects Version/s||0.4.0 [ 12313714 ]|
|Affects Version/s||0.3.0 [ 12313637 ]|
|Component/s||Query Processor [ 12312586 ]|
|Status||Patch Available [ 10002 ]||Resolved [ 5 ]|
|Fix Version/s||0.6.0 [ 12314524 ]|
|Resolution||Fixed [ 1 ]|
|Status||Open [ 1 ]||Patch Available [ 10002 ]|
|Field||Original Value||New Value|
|Assignee||Paul Yang [ pauly ]|