> Would the order of partition column in the where clause matter for >performance?
No, unless you have more complex predicates than an AND. There¹s one recent regression though - https://issues.apache.org/jira/browse/HIVE-10122 Which release are you on? > Also, how can I make sure that ³partition pruning² is working as >intended when checking the execution plan? explain extended <query> shows all the partitions being read via the Path -> Partition section. Cheers, Gopal
