hive-user mailing list archives

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



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



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’



or



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.

Mime
View raw message