Disabling metadata synchronization
By default, metadata is synchronized when refreshed/invalided across multiple Impala Virtual Warehouses that share a Database Catalog. When you run a command to refresh a table or invalidate metadata in any one of these Impala Virtual Warehouses, metadata is refreshed/invalidated in parallel. You learn how to disable this feature if you do not want to synchronize metadata for some reason.
- enable_reload_events = true (default)
- enable_reload_events = false
Metadata has to be synchronized when you make changes to the data that causes
inconsistent file metadata. For example:
To synchronize the file metadata in the catalog cache, you run a
refresh/invalidate command in a single virtual warehouse. The catalog cache across all
the Virtual Warehouses that share a Database Catalog is synchronized and consistent.
- You run LOAD DATA INPATH in one Virtual Warehouse that shares a Database Catalog with other Virtual Warehouses.
- External clients create, update, and delete partitioned files on the object store.
In this task, you disable metadata synchronization.
- The DWAdmin role is required to configure CDW.
- An Impala Virtual Warehouse running 1.6.1-b258 (released Feb 7, 2023) or later