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:
Total number of rows that were read