Datometry Documentation

The second generation of Hyper-Q bulk load error handling, generation 2 improves performance and provides more information about errors than the previous version of bulk load error handling, advanced adaptive error handling (AAEH). You enable generation 2 bulk load error handling using the Hyper-Q hint bulk_load_err_gen2.

If generation 2 bulk load error processing encounters an error, it will fall back to AAEH error handling for errors on DML operations other than INSERT. If you enable AAEH and generation 2 error handling in your Hyper-Q environment, AAEH (which you enable using the configuration parameter bulk_load_retry_max_error_rows), is ignored.

The syntax for bulk_load_err_gen2 is:

bulk_load_err_gen2 = true | false | force

where:

Hint Scope

The bulk_load_err_gen2 hint can be specified at the request, session, and global level. To learn more about Hyper-Q SQL hints, and how to use them within a SQL query, see About Hyper-Q SQL Hints.

SET QUERY_BAND = 'UtilityDataSize=LARGE;' FOR SESSION
--@dtm_bulk_load_err_gen2=true for session
BEGIN LOADING Employee ERRORFILES ErrorTable1,ErrorTable2 CHECKPOINT 50000;