Hi I find the solution, now there is no duplicate data occurred. Thank you sqoop import --connect 'jdbc:sqlserver://XX.XXX;database=XXXX' --username XX --password XXXX --table ActionItems --split-by ActionId --target-dir /user/hive/warehouse/project_tracking.db/actionitems --incremental append --check-column Lastupdateddate --last-value "2019-02-06 19:52:55.873" ... View more

@Nethaji R Any updates did my response resolve the issue or answer your question if so accept so the thread is marked as closed. ... View more

Hi Thank you for your reply I tried this method to insert csv data into hbase table that's working fine. My question is, i have a list of flat files i.e,.word, excel, image in my hdfs directory, i want to store all these data into one hbase table as a object. still i didn't get solution for this problem, please provide any suggestions for me. Thank you ... View more