Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop export with HCatalog, getting NULLs for datetime columns


Copy link to this message
-
Sqoop export with HCatalog, getting NULLs for datetime columns
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.
+
Sunita Arvind 2014-01-08, 13:46