hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From reveen joe <>
Subject Order of Partition column and Non Partition column in the WHERE clause
Date Tue, 19 May 2015 16:56:15 GMT

Would the order of partition column in the where clause matter for

For eg: would there be any difference in performance in the below queries?

select a from table where part_column = ‘y’  and non_part_column = ‘z’


select a from table where non_part_column = ‘z’ and part_column = ‘y’

Also, how can I make sure that “partition pruning” is working as intended
when checking the execution plan?

Thanks in advance.

View raw message