If logging is enabled for bulk load, a log file records information for each bulk load operation. Logging is enabled by specifying a file name and location for the log file using the setLogFile method.

The log file records the following types of information about each bulk load operation.

  • Total number of rows that were read
  • Total number of rows that successfully loaded
    Note: The total number of rows that successfully loaded is not provided for Microsoft Azure Synapse Analytics or Microsoft Analytics Platform System.
  • Total number of rows that failed to load

For example, the following log file shows that the 11 rows read were all successfully loaded.

/*----- Load Started: <Feb 25, 2009 11:20:09 AM EST>---------------------*/
Total number of rows read 11
Total number of rows successfully loaded 11
Total number of rows that failed to load 0

Enabling Logging on Windows

To enable logging using a log file named bulk_load.log located in the C:\temp directory, you would specify:

bulkLoad.setLogFile(C:\\temp\\bulk_load.log)
Note: If coding a path on Windows to the log file in a Java string, the backslash character (\) must be preceded by the Java escape character, a backslash. For example: C:\\temp\\bulk_load.log.

Enabling Logging on UNIX/Linux

To enable logging using a log file named bulk_load.log located in the /tmp directory, you would specify:

bulkLoad.setLogFile(/tmp/bulk_load.log)