You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2014/12/15 02:15:13 UTC

[jira] [Updated] (HIVE-9028) Enhance the hive parser to accept tuples in where in clause filter

     [ https://issues.apache.org/jira/browse/HIVE-9028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Navis updated HIVE-9028:
------------------------
    Fix Version/s:     (was: 0.14.0)
                   0.15.0

> 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.15.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)