Created 09-30-2016 08:58 AM
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
Created 10-02-2016 12:36 AM
You need to review timezone settings on sql server and on your cluster, you might have discrepancy with GMT vs local timezone.
Created 10-03-2016 07:12 AM
I have cheked timestamp on cluster as well as on SQL server ,both are in IST timezone.Is there any other possibility?