https://community.cloudera.com/t5/Support-Questions/SQOOP-IMPORT-map-column-hive-ignored/m-p/46242#M45636 I agree with Kerjo.. Type cast is further step but i want to get the data straightaway in date format. Tried --map-column-hive but it is getting ignored Thu, 13 Oct 2016 14:52:27 GMT manpreet2 2016-10-13T14:52:27Z