How can I import data from mysql to hive tables with incremental data

Question

How we can import  incremental data from MySQL to hive tables using Sqoop. While import from MySQL trying to add date column.

Answer 1

Hi@dharmendra,

It is common to perform one-time ingestion of data from an operational database to Hive and then require incremental updates periodically. You can perform periodic updates. Go through the below-given link. You will get the idea.

https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/bk_data-access/content/incrementally-updating-hive-table-with-sqoop-and-ext-table.html