sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vengala Reddy <vengalare...@gmail.com>
Subject Sqoop export with HCatalog, getting NULLs for datetime columns
Date Tue, 07 Jan 2014 21:02:38 GMT
I am trying to export HDFS data into SQL Server with Sqoop and HCatalog.


sqoop export --verbose --connect
'jdbc:sqlserver://ras-sql-q20.qa.c000.local\mssql2012;
database=IBCDW;username=sqoop;password=sqoop'
--table stgROLE --hcatalog-database ibcods --hcatalog-table care_role2.


CREATE EXTERNAL TABLE IF NOT EXISTS care_role(
client_id SMALLINT COMMENT 'The unique ID of the client sending files.  The
client will be supplied this number when originally setting up file
submissions.'
,care_role_id STRING
,care_role_desc STRING
,rec_load_dttm STRING
,rec_last_upd_dttm STRING
,rec_del_ind STRING
)
COMMENT 'A function performed by a physician on behalf of the member.'
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS SEQUENCEFILE


The below columns are datetime in SQL Server.
,rec_load_dttm datetime
,rec_last_upd_dttm datetime

When I export data, datetime fileds are getting populated as NULL values.

Please help me on this.

Mime
View raw message