You can specify additional Sqoop arguments and disable the Sqoop connector at the mapping level. The Sqoop arguments that you specify at the mapping level take precedence over the arguments that you specified in the JDBC connection.
Open the mapping that contains the data object for which you want to configure Sqoop properties.
Select the Read or Write transformation that is associated with the data object.
Click the
Advanced
tab.
To disable the Sqoop connector for the data object, select the
Disable Sqoop Connector
check box.
Perform one of the following steps:
To specify additional Sqoop import arguments for the data object, enter the import arguments in the
Additional Sqoop Import Arguments
text box.
To specify additional Sqoop export arguments for the data object, enter the export arguments in the
Additional Sqoop Export Arguments
text box.
The Data Integration Service merges the additional Sqoop arguments that you specified in the mapping with the arguments that you specified in the JDBC connection and constructs the Sqoop command. The Data Integration Service then invokes Sqoop on a Hadoop node.