I have one table in database where insertdate is of 'Date' type. However when I import the table into hive using sqoop values in hive tables are getting decremneted. Example. RDBMS --> insertdate='2013-04-01' Hive --> insertdate='2013-03-30' I have used below command to import data: sqoop import --connect 'jdbc:sqlserver://localhost;username=XXXXX;password=XXXXXXX;database=XXXXXXXXXX'--table tbl_name \ --warehouse-dir /user/hive/warehouse --m 1 \ --hive-import --hive-database db_name --hive-overwrite --null-string '\\N' --null-non-string '\\N' --hive-drop-import-delims ... View more