I am trying to write hive o/p into HDFS csv file then there is change is date timestamp column millisecond is missing in csv file Hive : (1750-01-01 00:00:00.0) csv : (1750-01-01 00:00:00)   script : hive -e "INSERT OVERWRITE DIRECTORY '/path/date/tab1/' ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE select * from table1 limit 5;" Hive o/p 123|1750-01-01 00:00:00.0||2029-09-09 14:29:44.0 csv file 123|1750-01-01 00:00:00||2029-00-04 14:29:44   Can someone let me know how to write same o/p in CSV  as we get using Hive? ... View more