DEFAULT_HINTS_INSERT_STATEMENT Query Option

The DEFAULT_HINTS_INSERT_STATEMENT query option sets the default hints for the INSERT statements with no optimizer hint specified.

When there are hints specified in an INSERT statement, these default hints are ignored.

You can specify multiple hints separated by ‘:‘.

For example:

  1. SET DEFAULT_HINTS_INSERT_STATEMENT=CLUSTERED;
  2. SET DEFAULT_HINTS_INSERT_STATEMENT=SHUFFLE;
  3. SET DEFAULT_HINTS_INSERT_STATEMENT=NOCLUSTERED:NOSHUFFLE;

The default hints apply to the HDFS and Kudu table formats and are ignored for the HBase table format.

Type: STRING

Default: none

Added in: Impala 3.3

Parent topic: Query Options for the SET Statement