Cloudera Docs

Setting up an Impala Virtual Warehouse

You learn how to set up a Unified Analytics Virtual Warehouse for Business Intelligence (BI), or ad-hoc querying. An Impala Virtual Warehouse can read full ACID tables in the Hive metastore, and can write insert-only ACID tables because you select the Impala engine type.

  1. Log in to the Data Warehouse service as DWAdmin.
  2. Go to the Virtual Warehouses tab and click New Virtual Warehouse.
    The Create Virtual Warehouse modal is displayed.
  3. Specify a name for your Virtual Warehouse and select an environment, database catalog, Impala, and Hue image versions.
  4. Select Impala as the Virtual Warehouse Type.
  5. Select a size for the Virtual Warehouse.
  6. Select Unified Analytics.
  7. Deselect Disable AutoSuspend if you intend to use Impala coordinator shutdown, which you enable in the next step.
    The Impala coordinator does not automatically shutdown unless the Impala executors are suspended.
  8. Configure Impala coordinator shutdown by turning on Allow Shutdown Of Coordinator and accept the default value Enabled Active-Passive in High Availability (HA).
    For the benefits and other information about Coordinator shutdown, see configure Impala coordinator shutdown.
  9. Set User Groups that can access endpoints, keys and values for Tagging the Virtual Warehouse.
  10. Customize other options as necessary.
  11. Click Create Virtual Warehouse.