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 !