title: How to convert bigint to datetime in hive?
body: <p>I had sqooped the data from teradata to Hive using sqoop import command.</p>
  
  <p>For one of the tables in teradata, I have a date field . After sqooping, my date field is appearing as a timestamp with bigint datatype.</p>
  
  <p>But I need the date field as a date datatype in hive table. Can anyone please suggest me in achieving this?</p>