Data Expiration in Hive and Presto Query Engines

The Hive version that you use might affect data expiration:

In Hive 0.13. data expirations take effect in the partitioning filter stage. However, in Hive 2 and Presto query engines, data expiration takes effect in the record reader. Therefore, Hive 0.13 might include more excluded data. For more information, see Hive 0.13/Hive 2 Code and Syntax Compatibility.