Hi All,   I am trying to achieve incremental sqoop import into hive when a new record is created as well when updates happen to the existing records.  We have tables having both created date column and modified date column. But the modified date column will be updated only when there is any update in the existing records and will remain null when a new record is inserted. Only the created date will be updated when new records are created.    So, when we try the incremental lastmodified option it always looks for the modified date column but our source tables doesnt have values in the modified date column always as it keeps NULL for new records and only updates the value when an existing table gets modified.    So, for this kind of source DB tables with such columns is there any solution in sqoop import.    Also, sqoop incremental with lastmodifed doesnt work with hive tables and we have to create a table already and then run this incremental lastmodified   "INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc. --incremental lastmodified option for hive imports is not supported. Please remove the parameter --incremental lastmodified."   So, please help on which approach will suit better to do an incremental import of our data into Hive tables.  Need a solution badly for this scenario. please help if you have done this before. ... View more