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, TRICKLE loads data only into WOS. 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 /*+ TRICKLE */ ...