GitHub user saucam opened a pull request:
https://github.com/apache/hive/pull/25
HIVE-9028: Enhance the hive parser to accept tuples in where in clause
filter
Currently, the hive parser will only accept a list of values in the where
in clause and the filter is applied only on a single column. Enhanced it to
accept filter on multiple columns.
So current support is for queries like :
Select * from table where c1 in (value1,value2,...value n);
Added support in the parser for queries like :
Select * from table where (c1,c2,... cn) in ((value1,value2...value n),
(value1' , value2' ... ,value n').... )
Have added support for these queries in spark sql
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/saucam/hive trunk
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/hive/pull/25.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #25
----
commit 30fa9f1e52b77f68080c2aa146b7f6a4edffd10b
Author: Yash Datta <yash.da...@guavus.com>
Date: 2014-12-05T05:36:46Z
HIVE-9028: Enhance the hive parser to accept tuples in where in clause
filter
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
