Tuning Impala Java tool options

After creating an Impala Virtual Warehouse, you can change the Java tool options. The options apply only to the Impala Catalog.

Tuning Impala Java tool options has the following limitations:

• The value of the JAVA_TOOL_OPTIONS represents JVM flags, but in this release, you can change only the Xmx and Xms values for CatalogD's JVM Heap.
• The Xmx flag value cannot be more than 18G.
• Floating point values for memory are not supported; only integers are supported.

Obtain the DWAdmin role.

1. Log in to the CDP web interface and navigate to the Data Warehouse service.
2. In the Data Warehouse service, click Overview in the left navigation pane.
3. In the Overview page under Virtual Warehouses, select a Virtual Warehouse, click , and select Edit.
4. Click Configurations.
5. In Impala catalogd, in Configuration files, select env.
6. Adjust the value of environment variables JAVA_TOOL_OPTIONS for Impala CatalogD.
7. Click Apply Changes.