Configuring Impala coordinator shutdown
To cut cloud expenses, you need to know how to configure Impala coordinators to automatically shutdown during idle periods. You need to know how to prevent unnecessary restarts. Monitoring programs that periodically connect to Impala can cause unnecessary restarts.
- Update impyla, jdbc, impala shell clients if used to connect to Impala.
- When you create a Virtual Warehouse of SQL engine
type Impala, and then you enable Unified Analytics, you can configure Impala
coordinator shutdown only if you also configure Active-Passive mode.
-
Select the Allow Shutdown of Coordinator option.
After Impala executors have been suspended, the Impala coordinator waits for the time period specified by theTrigger Shutdown Delaybefore shutting down.For example, ifAutoSuspend Timeout= 300 seconds andTrigger Shutdown Delay=150 seconds, after 300 seconds of inactivity Impala executors suspend, and then 150 seconds later, the Impala coordinator shuts down. -
Accept default values for other settings, or change the values to suit your use
case, and click Create Virtual Warehouse.
Click the tooltip
for information about a setting.
