SHUFFLE_DISTINCT_EXPRS Query Option

The SHUFFLE_DISTINCT_EXPRS query option controls the shuffling behavior when a query has both grouping and distinct expressions. Impala can optionally include the distinct expressions in the hash exchange to spread the data among more nodes. However, this plan requires one more hash exchange phase.

It is recommended that you turn off this option if the NDVs of the grouping expressions are high.

Type: Boolean; recognized values are 1 and 0, or true and false; any other value interpreted as false

Default: false