https://community.cloudera.com/t5/Support-Questions/SQOOP-IMPORT-map-column-hive-ignored/m-p/62297#M45643 <P>Hi kerjo,</P><P>&nbsp;</P><P>I was facing the same issue with <EM>map-column-java</EM> and <EM>map-column-hive</EM> while importing date/timestamp column from Oracle RDBMS to Hive parquet table using Sqoop. My Hive column is of type string.</P><P>Version CDH 5.12.1, Parquet 1.5.0.</P><P>&nbsp;</P><P>A partial workaround I discovered is to convert the Date column to string using a <STRONG>free form query</STRONG> in Sqoop.</P><P>&nbsp;</P><P>Input column in oracle (type Date):</P><P>&nbsp;</P><P>'16.11.2017 09:44:11'</P><P>&nbsp;</P><P><EM>--query</EM></P><P>&nbsp;</P><PRE>select t.trans_id, to_char(t.trans_date_sysdate) trans_date_char from test_table_1 t where $CONDITIONS</PRE><P>Result in Hive looks like this:</P><P>&nbsp;</P><P><SPAN><SPAN class="editorComponents notebook">16-NOV-17</SPAN></SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><SPAN><SPAN class="editorComponents notebook">Unfortunately, this is not enough, I am still not able to import the HH:mm:SS part. </SPAN></SPAN></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 28 Nov 2017 14:23:28 GMT AlexMulti 2017-11-28T14:23:28Z