Member since
09-30-2016
3
Posts
1
Kudos Received
0
Solutions
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?
... View more
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
... View more
Labels:
09-30-2016
07:10 AM
1 Kudo
I think you have missed Location argument while creating hive table,since this is the external table.
... View more