...
The Hive version that you use might affect data expiration:
In Hive 0.13. and Presto query engines, 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 than Hive 2019. 1 and Hive 2020.1. For more information, see see Hive 0.13/Hive 2 Code and Syntax Compatibility.
...