Hi Alberto,
If I'm not mistaken, to make sure that this work you need to give the proper annotation in your UDF code (deterministic, and maybe some other). You may also need to return a Constant Object Inspector in the unit method so that Hive knows that it can perform partition pruning with it. On Wed, 9 May 2018, 19:23 Alberto Ramón, <a.ramonporto...@gmail.com> wrote: > Hello > > We have a UDP to select the correct partition to read 'FindPartition': > Select * from TB where partitionCol =FindPartition(); > > How I can avoid a full scan of all partitions? > > > (Set MyPartition=FindPartition(); // Is not valid in Hive) >