How to do incremental update when I am loading data from SQL server to hive tables using sqoop without creating extra temporary tables ?
Incremental insert is working using below command.
--incremental append --check-column id --last-value 5
But update is not working using below
--incremental lastmodified --check-column UPDATE_DATE --last-value '2018-07-19 16:14:38'
@Deb, I think this is expected. Incremental imports mode can be used to retrieve only rows newer than some previously-imported set of rows.
There is no direct way to achieve the use case you are looking for. Having said that you can refer this document : https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_data-access/content/incrementally-updati...
Hope this helps.