https://community.cloudera.com/t5/Support-Questions/map-column-hive-not-creating-specific-column-dataype/m-p/115993#M78787 <P>The avro in Hive 1.1 is Avro 1.7.4, it does not support date types, those were introduced in Avro 1.8 that explains why they are not showing. You can confirm by looking in your Hive lib directory for specific avro version.</P><P><A href="https://issues.apache.org/jira/browse/AVRO-739">https://issues.apache.org/jira/browse/AVRO-739</A></P><P>I haven't tried it myself but if you can coerce sqoop into using avro 1.8.x maybe you can achieve what you want with date type, maybe try adding it to sqoop lib folder? If my answers were at all useful, please consider accepting the answer as best.</P> Tue, 21 Feb 2017 01:02:17 GMT aervits 2017-02-21T01:02:17Z