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
Parent topic: Query Options for the SET Statement