[SQOOP-3186] Add Sqoop1 (import + --incremental + --check-column) support for functions/expressions

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Assignee: Eric Lin
• Reporter: Markus Kemper
• Created: 08/May/17 15:52
• Updated: 05/Jul/18 08:54

Description

Add Sqoop1 (import + --incremental + --check-column) support for functions/expressions, for example:

Example

sqoop import \
--connect $MYCONN --username $MYUSER --password $MYPSWD \
--table T1 --target-dir /path/directory --merge-key C1 \
--incremental lastmodified  --last-value '2017-01-01 00:00:00.0' \
--check-column nvl(C4,to_date('2017-01-01 00:00:00')

Issue Links

• is related to: SQOOP-3067 Add an cmd line option to support split-by feature for database functions/expressions