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:
SET DEFAULT_HINTS_INSERT_STATEMENT=CLUSTERED;
SET DEFAULT_HINTS_INSERT_STATEMENT=SHUFFLE;
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