https://community.cloudera.com/t5/Support-Questions/SQOOP-IMPORT-map-column-hive-ignored/m-p/62380#M45645 <P>EDIT: I have successfuly imported Date column from Oracle into Hive by modifiyng my query:</P><P>&nbsp;</P><PRE>select t.trans_id, to_char(t.trans_date_sysdate,'YYYYMMDD_HH24MiSS') trans_date_char trans_date_char from test_table_1 t where $CONDITIONS </PRE><P>&nbsp;</P> Thu, 30 Nov 2017 12:45:38 GMT AlexMulti 2017-11-30T12:45:38Z