[HIVE-11600] Hive Parser to Support multi col in clause (x,y..) in ((..),..., ())

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.0, 2.0.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 19/Aug/15 06:01
• Updated: 28/Nov/19 06:15
• Resolved: 04/Sep/15 17:17

Description

Current hive only support single column in clause, e.g.,

select * from src where  col0 in (v1,v2,v3);

We want it to support

select * from src where (col0,col1+3) in ((col0+v1,v2),(v3,v4-col1));

Issue Links

• causes: HIVE-17395 HiveServer2 parsing a command with a lot of "("
• causes: HIVE-18624 Parsing time is extremely high (~10 min) for queries with complex select expressions
• is related to: HIVE-11468 Vectorize: Struct IN() clauses
• relates to: HIVE-11738 Hive Parser to Support multi col in clause (x,y..) in (select ... from ..)
• links to: RB