Configuring Impala Statestore high availability

You can configure High Availability (HA) for Impala Statestore pods in a Virtual Warehouse. One Statestore pod operates in active mode, the other in passive mode. The passive pod serves as a backup and takes over if the active pod goes down.

When you create an Impala Virtual Warehouse, you use the same UI dropdown to configure Impala coordinator, covered in the previous topic, and Database Catalog, and Statestore high availability. You can choose one of the following options:

Disabled: Disables Impala coordinator and Database Catalog, and Statestore high availability
Enabled (Active-passive): Runs multiple coordinators (one active, one passive) and Database Catalogs, and Statestore (one active, one passive)
Enabled (Active-active): Runs multiple coordinators (both active) and Catalog daemon (one active, one passive), and Statestore (one active, one passive)

You must obtain the DWAdmin role.

Follow instructions for Adding a new Virtual Warehouse.
In Size, select the number of executors, for example, xsmall - 2 Executors.
A number of additional options appear, including High availability.
In High availability (HA), accept the default Enabled (Active-Passive) or Enabled (Active-Active).
Either option enables Statestore high availability in active-passive mode.
Accept default values for other settings, or change the values to suit your use case.
Click the tooltip for information about settings.
Click Create Virtual Warehouse.