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

Hi , I have huge volume of data it is showing fine in Imapla and when I am trying to Query from Hive it is displaying Null values..Any suggestions  on this  ? ... View more