Interview Questions and Answers

The --direct option enables direct export or import between Hadoop and the database without using HDFS as an intermediary.

The --direct-split-size option is used to specify the number of bytes per split when using direct mode for imports and exports.

Example:

sqoop import --connect jdbc:mysql://localhost:3306/db --table mytable --direct --direct-split-size 1000000

The --direct-import option is used to import data directly into the database without using HDFS as an intermediate storage.

The --validate option is used to perform data validation during import by comparing the source and target data counts.

Example:

sqoop import --connect jdbc:mysql://localhost:3306/db --table mytable --validate

The --direct-split-size option is used to specify the number of bytes per split when using direct mode for imports and exports.

Example:

sqoop import --connect jdbc:mysql://localhost:3306/db --table mytable --direct --direct-split-size 1000000

The --direct-split-size option is used to specify the number of bytes per split when using direct mode for imports and exports.

Example:

sqoop import --connect jdbc:mysql://localhost:3306/db --table mytable --direct --direct-split-size 1000000

The --autoreset-to-one-mapper option automatically resets the number of mappers to one if the initial split size is larger than the total number of rows in the table.

Example:

sqoop import --connect jdbc:mysql://localhost:3306/db --table mytable --autoreset-to-one-mapper