Limit scanned partitions

Before Hive 1.0 a configuration property was added for limited scanned partitions that was replaced by another property.

Before Upgrade to CDP

To protect the cluster, the hive.limit.query.max.table.partition configuration property was added to Hive. The property limits the table partitions involved in a table scan. In Hive 2.2.0, the hive.metastore.limit.partition.request was added to replace the hive.limit.query.max.table.partition. The hive.limit.query.max.table.partition support was deprecated.

After Upgrade to CDP

In Hive 3, support for hive.limit.query.max.table.partition was removed (HIVE-17965). Only replacement hive.metastore.limit.partition.request is supported to limit the number of partitions that can be requested from the Metastore for a table. A query is not executed if it fetches more partitions per table than the limit configured. A value of -1 means unlimited.

Action Required

Find any settings of hive.limit.query.max.table.partition and change your code to use hive.metastore.limit.partition.request.