Advanced Parameter Configuration Dialog Box
When you specify the copy mode Parallel, you can define additional Sqoop settings using the Advanced Parameter Configuration dialog box. If these parameters are left blank, the operator uses the Team Studio default Sqoop settings.
| Label | Description |
|---|---|
| Parameter Name | Sqoop parameter. Select from the list of available parameters.
Enter Sqoop advanced parameters according to the Sqoop User Guide rather than as a Sqoop CommandLineClient. For example, use --verbose instead of --verbose=true. See http://sqoop.apache.org for details. |
| Parameter Value | Value of the parameter to set for the parameter currently selected under Parameter Name. |
| Create | Click to add the new parameter key-value pair. |
| Delete | Click to remove a parameter. |
Additional notes
- sqoop.export.records.per.statement
- When you copy large or wide data sets, you must configure the
sqoop.export.records.per.statement parameter. By default,
sqoop.export.records.per.statement is set for 1000 records. You can override this default using the
Advanced Parameters Configuration capability to allow 500 records to be copied in the batch as follows:
sqoop.export.records.per.statement=500
This setting works only if batch copy is enabled on the database. It does not work for Vertica and Teradata databases.
You can specify these advanced parameters for the Parallel copy mode in the Copy to Database and Copy to Hadoop operators.