[
https://issues.apache.org/jira/browse/HIVE-9028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14235119#comment-14235119
]
ASF GitHub Bot commented on HIVE-9028:
--------------------------------------
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
----
> Enhance the hive parser to accept tuples in where in clause filter
> ------------------------------------------------------------------
>
> Key: HIVE-9028
> URL: https://issues.apache.org/jira/browse/HIVE-9028
> Project: Hive
> Issue Type: Improvement
> Components: Parser
> Affects Versions: 0.13.1
> Reporter: Yash Datta
> Fix For: 0.14.0
>
>
> 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').... )
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
