Impala configuration differences in CDH and CDP
There are some configuration differences related to Impala in CDH and CDP. These differences are due to the changes made in CDP for the optimal interoperability between Hive and Impala for improved user experience. Review the changes before you migrate your Impala workload from CDH to CDP.
Default Value Changes in Configuration Options
| Configuration Option | Scope | Default in CDH 6.x | Default in CDP |
|---|---|---|---|
DEFAULT_FILE_FORMAT |
Query | TEXT |
PARQUET |
hms_event_polling_interval_s |
Catalogd | 0 |
2 |
ENABLE_ORC_SCANNER |
Query | TRUE |
FALSE |
use_local_catalog |
Coordinator / Catalogd | false |
true |
catalog_topic_mode |
Coordinator | full |
minimal |
New Configuration Options
| Configuration Option | Scope | Default Value |
|---|---|---|
default_transactional_type |
Coordinator | insert_only |
DEFAULT_TRANSACTIONAL_TYPE |
Query | insert_only |
disable_hdfs_num_rows_estimate |
Impalad | false |
disconnected_session_timeout |
Coordinator | 900 |
PARQUET_OBJECT_STORE_SPLIT_SIZE |
Query | 256 MB |
SPOOL_QUERY_RESULTS |
Query | FALSE |
MAX_RESULT_SPOOLING_MEM |
Query | 100 MB |
MAX_SPILLED_RESULT_SPOOLING_MEM |
Query | 1 GB |
FETCH_ROWS_TIMEOUT_MS |
Query | N/A |
DISABLE_HBASE_NUM_ROWS_ESTIMATE |
Query | FALSE
|
enable_insert_events |
TRUE |