[jira] [Created] (HIVE-14393) Tuple in list feature fails if there's only 1 tuple in the list

["Carter Shanklin (JIRA)" <ji...@apache.org>]

Carter Shanklin created HIVE-14393:
--------------------------------------

             Summary: Tuple in list feature fails if there's only 1 tuple in the list
                 Key: HIVE-14393
                 URL: https://issues.apache.org/jira/browse/HIVE-14393
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.1.0
            Reporter: Carter Shanklin


So this works:

{code}
hive> select * from test where (x,y) in ((1,1),(2,2));
OK
1	1
2	2
Time taken: 0.063 seconds, Fetched: 2 row(s)
{code}

And this doesn't:
{code}
hive> select * from test where (x,y) in ((1,1));
org.antlr.runtime.EarlyExitException
	at org.apache.hadoop.hive.ql.parse.HiveParser_IdentifiersParser.precedenceEqualExpressionMutiple(HiveParser_IdentifiersParser.java:9510)
{code}

If I'm generating SQL I'd like to not have to special case 1 tuple.

As a point of comparison this works in Postgres:
{code}
vagrant=# select * from test where (x, y) in ((1, 1));
 x | y
---+---
 1 | 1
(1 row)
{code}

Any thoughts on this [~pxiong] ?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)