Automate partition discovery and repair
Apache Hive can automatically and periodically discover discrepancies in partition metadata in the Hive metastore and in corresponding directories, or objects, on the file system. After discovering discrepancies, Hive performs synchronization. Automated partition discovery is useful for processing log data, and other data, in Spark and Hive catalogs.
discover.partitions table property enables and disables
synchronization of the file system with partitions. In external partitioned tables,
this property is enabled (
true) by default when you create the
table. To a legacy external table (created using a version of Hive that does not
support this feature), you need to add
discover.partitions to the
table properties to enable partition discovery.
By default, the discovery and synchronization of partitions occurs every 5 minutes, but you can configure the frequency as shown in this task.
Assuming you have an external table created using a version of Hive that does not support partition discovery, enable partition discovery for the table.
ALTER TABLE exttbl SET TBLPROPERTIES ('discover.partitions' = 'true');
Set synchronization of partitions to occur every 10 minutes expressed in
ALTER TABLE exttbl SET TBLPROPERTIES ('metastore.partition.management.task.frequency' = 600);