is this behavior for Hive on TEZ only?
or for Hive on MapReduce too?

On Tez, I think yes: evaluate functions and sub-queries and recompile to
partition pruning.
but in CDH compile all one time
On 16 May 2018 at 07:58, Furcy Pin <[EMAIL PROTECTED]> wrote: