https://community.cloudera.com/t5/Support-Questions/csv-imported-from-local-its-not-taking-date-values-as/m-p/282068#M209734 <P>Hi&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/70322">@Rak</a>&nbsp;;</P><P>&nbsp;</P><P>here the script :</P><P>CREATE EXTERNAL TABLE IF NOT EXISTS sample_date (sc_code string, ddate timestamp, co_code DECIMAL, high DECIMAL, low DECIMAL, open DECIMAL, close DECIMAL, volume DECIMAL, no_trades DECIMAL, net_turnov DECIMAL, dmcap DECIMAL, return DECIMAL, factor DECIMAL, ttmpe DECIMAL, yepe DECIMAL, flag string)<BR />ROW FORMAT<BR />DELIMITED FIELDS TERMINATED BY ' '<BR />LINES TERMINATED BY '\n'<BR />STORED AS TEXTFILE<BR />LOCATION '/lab/itim/ccbd/helmi/sampleDate'<BR />tblproperties('skip.header.line.count'='1');</P><P><BR />ALTER TABLE sample_date<BR />SET SERDEPROPERTIES ("timestamp.formats"="MM/DD/YYYY");</P><P>&nbsp;</P><P>Could you accept the answer please ?</P><P>&nbsp;</P><P>Best,</P><P>Helmi KHALIFA</P> Tue, 05 Nov 2019 09:21:48 GMT helmi_khalifa 2019-11-05T09:21:48Z