Tuning Impala The following sections explains procedures for tuning Impala queries and other SQL operations. Setting Up HDFS CachingSet up HDFS caching with Impala for improved performance.Setting up Data Cache for Remote ReadsIn CDP public cloud, the Impala remote data cache is enabled by default in Cloudera Data Warehouse and in most Data Hub templates that include Impala like Data Mart. However in Data Hub, you can enable or disable the data cache as needed through Cloudera Manager.Configuring Dedicated Coordinators and ExecutorsConfigure a dedicated coordinator and a dedicated executor roles to improve scalability of Impala.