List of predefined resource templates

CDW provides predefined resource templates for Hive, Impala, Database Catalog, and Data Visualization pods. Default Resources is used as the default resource template whenever you create a new Virtual Warehouse and Data Visualization instance, or edit an existing Database Catalog. Medium and Large Resources are double and triple the default preset respectively. For initial exploration and proof of concept use cases, you can use the Reduced Resources template. The predefined resource templates are read-only.

Data Visualization

Table 1. Default resources for Data Visualization subcomponents
Resource type Resource limit for webapp
CPUs 2
Memory 8192 MB

Database Catalog

Table 2. Default resources for Database Catalog subcomponents
Resource type Resource limit
Hive Query Processor HMS
CPUs 2 4
Memory 8192 MB 24576 MB
Xmx - 6432 M

Hive

Table 3. Default resources for Hive subcomponents
Resource type Resource limit
HS2 Hue backend Query coordinator Query executor Standalone compute operator Standalone query executor
CPUs 4 1 1 12 0.2 14
Memory 16384 MB 8192 MB 4096 MB 116736 MB 2048 MB 120832 MB
Scratch - - - 280 GiB - 280 GiB
Cache - - - 280 G - 280 GiB
Overhead size - - - 40 GiB - 40 GiB
Xms 8 G - 2 G 24 G - 49 G
Xmx 11468 M - 2457 M 48 G - 98 G
Xss - - - 256 k - 256 k
Max Direct Memory Size - - - 64 G - 20 G
Wait Queue size - - - 10 - 10

Impala

Table 4. Default resources for Impala subcomponents
Resource type Resource limit
Huebackend autoscaler catalogd Usage monitor Impala coordinator Impala executor Impala proxy statestored
CPUs 1 1 1 0.1 14 14 1 1
Memory 8192 MB 1024 MB 8192 MB 256 MB 112640 MB 116736 MB 1024 MB 1024 MB
Scratch - - - - 300 GiB 300 GiB - -
Cache - - - - 200 GiB 200 GiB - -
Overhead size - - - - 58 GiB 58 GiB - -
Xms - - 2 G - 2 G 2 G - -
Xmx - - 4 G - 25 G 4 G - -
Xss - - - - - - - -
Max Direct Memory Size - - - - - - - -
Wait Queue size - - - - - - - -

Unified Analytics

Table 5. Default resources for Hive and Impala subcomponents required to run Unified Analytics
Resource type Resource limit
HS2 Query coordinator Query executor Standalone query executor
CPUs 4 1 12 14
Memory 16384 MB 4096 MB 116736 MB 120832 MB
Scratch - - 280 GiB 280 GiB
Cache - - 280 GiB 280 GiB
Overhead size - - 40 GiB 40 GiB
Xms 8 G 2 G 24 G 49 G
Xmx 11468 M 2457 M 48 G 98 G
Xss - - 256 k 256 k
Max Direct Memory Size - - 64 G 20 G
Wait Queue size - - 10 10

Glossary

Memory
Physical Random Access Memory (RAM) available on a node (also called a worker machine) in a cluster. This memory resource is crucial for running pods in Kubernetes.
CPU
CPU (Central Processing Unit) refers to the processing power available on a node in the cluster.
Xmx
Maximum memory allocation pool for a Java Virtual Machine (VM).
Xms
Initial memory allocation pool for a Java VM.
Xss
Java VM configuration for -Xss (thread stack size).
Cache size
Size of the data cache.
Scratch size
Limit of Impala scratch space.
Overhead size
Size for resources used by tools run by the containers.
Max Direct Memory Size
Java VM configuration for -XX:MaxDirectMemorySize (limit for Direct Byte Buffers).
Wait queue size
Overhead buffer for hive.query.isolation.slots.per.node. The total number of concurrent tasks the Hive query executor can process is the sum of the available CPU cores and the value you specify in this field.