question csv imported from local its not taking date values as timestamp and it displays null in Support Questions

question csv imported from local its not taking date values as timestamp and it displays null in Support Questions https://community.cloudera.com/t5/Support-Questions/csv-imported-from-local-its-not-taking-date-values-as/m-p/281712#M209537 Hello Sir,     when i import Csv from local its not taking date values as timestamp and it displays null in hive actually when i use `date` timestamp the values show null and  when i use `date` string it shows but i need to merge with another table where `date` timestamp so merge isn't happening Thu, 31 Oct 2019 10:52:08 GMT Rak 2019-10-31T10:52:08Z