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

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.13.1
• Component/s: Parser
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Yash Datta
• Created: 05/Dec/14 05:42
• Updated: 27/Jun/20 00:25

Description

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

Issue Links

• is required by: SPARK-4762 Add support for tuples in 'where in' clause query
• links to: GitHub Pull Request #25