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