For databases created in Vertica releases ≥ 9.3, Vertica ignores load options and hints and defaults to a load method of DIRECT. You can configure this behavior with configuration parameter DMLTargetDirect.

In databases created in versions of Vertica prior to 9.3, AUTO loads table data initially into WOS until the space budgeted for the load is exceeded. Then the load switches and writes the remainder of the data to ROS. This hint overrides the table's load method.

The following statements support this hint:

For details, see Choosing a Load Method in the Administrator's Guide.


statement-name /*+ AUTO */ ...