https://community.cloudera.com/t5/Support-Questions/map-column-hive-not-creating-specific-column-dataype/m-p/115992#M78786 <P>Hi <A rel="user" href="https://community.cloudera.com/users/393/aervits.html" nodeid="393" target="_blank">@Artem Ervits</A></P><P>Yes I could see the java class changes related the date field (F_INI_APPEARANCE_DATE) and below is the code generated in the class file,</P><P>Let me know your thoughts on this..</P><P>But why type is not showing in the .metadata file, attached the sample image,</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="12689-sqoop-map-column-hive-date-attribute-issue.png" style="width: 868px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/23064i063F53C75FEF15D9/image-size/medium?v=v2&amp;px=400" role="button" title="12689-sqoop-map-column-hive-date-attribute-issue.png" alt="12689-sqoop-map-column-hive-date-attribute-issue.png" /></span></P><P><STRONG>sample code:-</STRONG></P><PRE> private java.sql.Timestamp F_INI_APPEARANCE_DATE; public java.sql.Timestamp get_F_INI_APPEARANCE_DATE() { return F_INI_APPEARANCE_DATE; } public void set_F_INI_APPEARANCE_DATE(java.sql.Timestamp F_INI_APPEARANCE_DATE) { this.F_INI_APPEARANCE_DATE = F_INI_APPEARANCE_DATE; } public QueryResult with_F_INI_APPEARANCE_DATE(java.sql.Timestamp F_INI_APPEARANCE_DATE) { this.F_INI_APPEARANCE_DATE = F_INI_APPEARANCE_DATE; return this; } </PRE> Mon, 19 Aug 2019 10:56:09 GMT SparkLearner 2019-08-19T10:56:09Z