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.
