[HIVE-14885] Support PPD for nested columns

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1.0
• Component/s: Logical Optimizer, Serializers/Deserializers
• Assignee: Unassigned
• Reporter: Xuefu Zhang
• Created: 04/Oct/16 17:02
• Updated: 04/Oct/16 17:10

Description

It looks like that PPD doesn't work for nested columns, at least not for Parquet. For a given schema

hive> desc nested;
OK
a                   	int                 	                    
b                   	string              	                    
c                   	struct<d:int,e:string>	                    

PPD works for a query like

select * from nested where a=1;

while NOT for

select * from nested where c.d=2;

Issue Links

• is related to: HIVE-10666 Improvement for Parquet Predicate Push down on Hive