https://community.cloudera.com/t5/Support-Questions/map-column-hive-not-creating-specific-column-dataype/m-p/115989#M78783 <P>Hello,</P><P>I recently started working on sqoop and HDFS related stuffs and I faced an issue by using<STRONG> </STRONG><STRONG>--map-column hive</STRONG></P><P>The datatype of the specified column doesn't change and below is the sqoop commmand to hdfs as parquet file,</P><PRE>sqoop import -Dmapreduce.job.queuename=xxxxx--connect jdbc:oracle:thin:@xxxx:1521:xxx--username xxxx--password xxx --query "SELECT * FROM imdb_pub_f_initiatives_v WHERE F_Ini_CouNTRY_CODE IN ('FR','XGL') AND \$CONDITIONS" --split-by f_ini_code -m 20 --map-column-hive "F_INI_APPEARANCE_DATE=date" --as-parquetfile --delete-target-dir --target-dir /user/ramaga09/gpub/FR/initiative/imdb_pub_f_initiatives_v2</PRE><P>I am running Sqoop version: 1.4.6-cdh5.5.2m, when I checked in the _metadata files in HDFS and I could see as "long" changes were not reflecting.</P><P>Please correct me if am doing any wrong.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="12688-sqoop-map-column-hive-date-attribute-issue.png" style="width: 868px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/23065i007801B5912441EE/image-size/medium?v=v2&amp;px=400" role="button" title="12688-sqoop-map-column-hive-date-attribute-issue.png" alt="12688-sqoop-map-column-hive-date-attribute-issue.png" /></span></P><P>Many Thanks,</P><P>Ganeshbabu R</P> Mon, 19 Aug 2019 10:56:17 GMT SparkLearner 2019-08-19T10:56:17Z