1.

When The Source Data Keeps Getting Updated Frequently, What Is The Approach To Keep It In Sync With The Data In Hdfs Imported By Sqoop?

Answer»

sqoop can have 2 approaches.

  1. To use the incremental parameter with append OPTION where value of some columns are CHECKED and only in case of modified values the row is imported as a new row.
  2. To use the incremental parameter with lastmodified option where a date column in the SOURCE is checked for records which have been UPDATED after the LAST import.

sqoop can have 2 approaches.


Discussion

No Comment Found

Related InterviewSolutions