Support Questions
Find answers, ask questions, and share your expertise
Alert: Please see the Cloudera blog for information on the Cloudera Response to CVE-2021-4428

incremental import using sqoop with modified records


Hi Guys!

I found out how to incrementally import the data using sqoop into hive. When I use --incremental append I get any new records added to the source rdbms into hive. However, when some existing record is altered and a modified date column value is updated in the rows, we need to make the import work as equally. Basically, this import should add the new rows and update the edited existing rows into hive. When I try to use sqoop incremental lastmodified it says that it doesn't work with hive. any help on achieving this scenario is much appreciated. Thank you !