Hi, Below is the solution. I have checked in hdfs level for the date format and have given the same order in "formats" value as below.   My Date Format : 2019-02-02   Alter Command : ALTER TABLE <TN> SET SERDEPROPERTIES ("timestamp.formats"="yyyy-mm-dd'");   Thanks ... View more