I have HIVE external table created in AVRO format. Data stored on S3 location. Now i am creating snowflake table on same data file stored on s3 in avro format. But getting issue with date column. Date is not coming correctly although string and int data are coming correctly in snowflake table.
data in hive table( col1 is timestamp data type in hive table):
col1 2021-02-04 10:02:31
data in snowflake table:
col1 53066-07-15 12:56:40.000
sql to create snowflake table:
CREATE OR REPLACE EXTERNAL TABLE test1 ( col1 timestamp as (value:col1::timestamp), ) WITH LOCATION = @S3_location/folder/ AUTO_REFRESH = TRUE FILE_FORMAT = 'AVRO';"