Question

What is the default number of rows Sqoop will export per transaction?

A) 100
B) 1,000
C) 10,000
D) 100,000

Answer 1

The default number of rows Sqoop exports per transaction is 10,000. This is configurable with specific Sqoop options for varying transaction sizes.

Step-by-step explanation:

The default number of rows that Sqoop will export per transaction is C) 10,000.

When performing an export operation, Sqoop divides the export process into multiple transactions, each handling a subset of the dataset.

Adjusting the number of rows per transaction can be done using the --batch option for smaller transactions or the --export-dir option to specify the input directory for the export.