Cisco Cisco Workload Automation 6.3 User Guide
35
Using the Sqoop Adapter
Defining Sqoop Jobs
Other Tab
Note:
You can click the Variables button to insert a predefined variable into a selected field on this tab.
In the
Output Formatting
section, enter the following:
Use Default Delimiters
– Select this option to use MySQL's default delimiter set. (fields: , lines: \n escaped-by: \
optionally-enclosed-by: ')
Column Delimiters
– Sets the field separator character
Line Delimiters
– Sets the end-of-line character
Enclosed By
– Sets a required field enclosing character
Escaped By
– Sets the escape character
Optionally Enclosed By
– Sets a field enclosing character
In the
Input Parsing
section, enter the following:
Column Delimiters
– Sets the input field separator
Line Delimiters
– Sets the input end-of-line character
Enclosed By
– Sets a required field encloser
Escaped By
– Sets the input escape character
Optionally Enclosed By
– Sets a field enclosing character