Creating custom pod configurations for Impala Virtual Warehouses
You can configure the resources used by Impala Virtual Warehouses in Cloudera Data
Warehouse (CDW) Private Cloud environments to optimize Impala performance or to control
resource usage in the environment.
When you create a Virtual Warehouse, CDW allocates standard resources to the
Warehouses that are suitable for most workloads. You can control the size of the Virtual
Warehouse at the time of creation by choosing the number of nodes to be used. By using
custom pod configurations, you can also change the resources used by the critical Impala
components, such as the coordinators, executors, and catalog daemons to pack a
particular number of pods into a Kubernetes node or to create extra-large daemons to
handle specific workloads.
Log in to the Data Warehouse service as a DWAdmin.
Go to your environment and click > Edit.
The Environment Details page is displayed.
Click the EDIT POD CONFIGURATIONS tab.
A pod configuration is a named resource that is configured at the environment
level.
Select one of the following two pod configuration options from the
Select Pod Configuration section:
The Cdw Defaults option is selected by default.
CDW uses default values for the pods if a specific pod configuration is not
used.
Select the 1 x Node option for allocation of most
node resources found in the environment, to the Impala executors and
coordinators.
The following image shows the two default pod configurations:
Click COPY CONFIG to create and edit a new configuration
with the option that you selected earlier as the basis.
Specify the name for your configuration in the Cloned Config
Name field.
Optional: Enter a description for the new configuration in the
Description field.
Click CREATE NEW CONFIG and then click
APPLY under the EDIT POD
CONFIGURATION tab.
A new pod configuration is created, which you can now
customize.
Specify the values for the following parameters under the
Coordinator section:
Memory
CPU
Xmx (maximum memory allocation pool for a Java Virtual
Machine)
Xms (initial memory allocation pool for a Java Virtual
Machine)
AC Slots (admission_control_slots flag)
Cache (size of the data cache)
Scratch (limit of Impala scratch space)
Specify the values for the following parameters under the
Executor section:
Memory
CPU
Xmx (maximum memory allocation pool for a Java Virtual
Machine)
Xms (initial memory allocation pool for a Java Virtual
Machine)
AC Slots (admission_control_slots flag)
Cache (size of the data cache)
Scratch (limit of Impala scratch space)
Specify the values for the following parameters under the
Catalog section:
Memory
CPU
Xmx (maximum memory allocation pool for a Java Virtual
Machine)
Xms (initial memory allocation pool for a Java Virtual
Machine)
Specify the values for the following parameters under the Default
Settings section:
MaxQueryMemLimit
MinQueryMemLimit
mt_dop
Click APPLY under the EDIT POD
CONFIGURATION tab to save the custom settings.
The “Configuration update initiated” message is displayed.
Optional: Click the Set as default configuration toggle button to
make this a default pod configuration.
This makes a pod configuration the default configuration at the environment
level.
Click APPLY at the top of the Environment Details
page.
The new pod configuration becomes available in the Pod
Config drop-down menu as shown in the following image. You can
select this Impala pod configuration while creating a new Impala Virtual
Warehouse:
While adding a new Impala Virtual Warehouse, you can select
the Pod Configuration to be used for resource allocation. The default value is "Cdw
Defaults", but you can select other configurations available in your environment that
you created using these steps.