https://community.cloudera.com/t5/Support-Questions/map-column-hive-not-creating-specific-column-dataype/m-p/115990#M78784 <P><A rel="user" href="https://community.cloudera.com/users/16159/babuganesh0708.html" nodeid="16159">@Ganeshbabu Ramamoorthy</A> can you remove the double quotes and try again? Also, you'd mentioned CDH, what version of Hive is it? Date type was only introduced in Hive 0.12, chance is CDH does not include it? <A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Date/TimeTypes" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Date/TimeTypes</A></P><PRE>--map-column-hive F_INI_APPEARANCE_DATE=date</PRE><P>I also recommend looking at the Java class code generated after you run this job in the directory you execute sqoop from, in there you should be able to find the type it generates.</P> Mon, 20 Feb 2017 23:18:22 GMT aervits 2017-02-20T23:18:22Z