Impala warehouse configuration options
You can configure a number of parameters while configuring an Impala Virtual Warehouse
in Cloudera Data Warehouse
on premises . These parameters help you to provision
high-performance Impala Virtual Warehouses and enable you to optimally utilize
compute resources.
Workload Aware Auto-Scaling in Impala Spill Impala queries to external storage Cloudera Data Warehouse on on premises enables you to write intermediate files during large sorts, joins, aggregations, or analytic function operations to a remote scratch space on HDFS or Ozone.Enabling Unified Analytics for Impala Virtual Warehouses in Cloudera Data Warehouse on premises Auto-suspend Virtual Warehouses Configuring Impala coordinator shutdown To optimize resource utilization , 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.Auto-scaling Impala Virtual Warehouses Cloudera Data Warehouse Private Cloud has an auto-scaler process that works with coordinators and executors to make resources available for queued queries. This ensures that workload demand is met without wasting cloud resources.About the Impala Autoscaling Dashboard Configuring Impala coordinator high availability Configuring fe_service_threads in Cloudera Data Warehouse on premises Cloudera Data Warehouse UI. 