Athena engine 3 External Table Timestamp issue for parquet

1

I have parquet file with milliseconds field (example 1686900160123) When I create external table in Athena engine 2 it seems correctly for S3 parquet files But In Athena engine 3 all fields have value with 1970-01-01 date, for example 1970-01-01 12:45:32.021

CREATE EXTERNAL TABLE export_data.konnecto_daily_export_US_parq ( eventdate timestamp COMMENT '' ) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' ...

asked a year ago132 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions