Cisco Cisco Workload Automation 6.3 User Guide

Using the Sqoop Adapter

Defining Sqoop Jobs

Export Job Task

Details Tab

You can click the Variables button to insert a predefined variable into a selected field on this tab.



 – HDFS source path for the export that contains the source data.



 – Select the table you want to use to populate in the database.



– Enter the name of the jar to export the record class from.



 – Depending on the target database, you can update rows if they exist in the database already or 

insert rows if they do not exist yet. By default, the export is carried out using INSERT statements. By checking the 

 option, you can choose to use UPDATE statements or INSERT and UPDATE statements together. 

The list box next to the 

 option allows you to select the desired update mode.



 – Anchor columns to use for updates. Use a comma separated list of columns if there 

is more than one column. This is a mandatory field if 

is selected.



 – Use batch mode for underlying statement execution.



 – Select to use the direct export fast path. 

MySQL provides a direct mode for exports as well, using the 

 tool. This may be higher-performance 

than the standard JDBC codepath. When using export in direct mode with MySQL, the MySQL bulk utility 

 must be available in the shell path of the task process.



 – Select the number of map tasks to export in parallel.