search

exasol / athena-virtual-schema

Virtual Schema for connecting Athena as a data source to Exasol
MIT License
0 stars 1 forks source link

TS(9) support in Athena VS #26

Open redcatbear opened 2 months ago

redcatbear commented 2 months ago

Situation

We need to support nanosecond timestamp resolution.

Acceptance Criteria

redcatbear commented 2 months ago

It looks from the documentation that Athena only support millisecond resolution: https://docs.aws.amazon.com/athena/latest/ug/data-types.html

There is a weird workaround for TS(6) for a corner case, but I highly doubt that using this is a good idea. https://docs.aws.amazon.com/athena/latest/ug/engine-versions-reference-0003.html#engine-versions-reference-0003-timestamp-precision-unload-ctas-iceberg