Solved it using, CREATE EXTERNAL TABLE test ( id int, ts timestamp) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ( 'serialization.format' = ',', 'field.delim' = ',', "timestamp.formats"="yyyy-MM-dd HH:mm:ss.SSSSSS+00" ) LOCATION 's3://user/'
... View more
