Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support Writing Int64 timestamp MICROS unit #362

Closed
michael-mckinney opened this issue Jun 29, 2023 · 1 comment · Fixed by #448
Closed

Support Writing Int64 timestamp MICROS unit #362

michael-mckinney opened this issue Jun 29, 2023 · 1 comment · Fixed by #448
Assignees
Milestone

Comments

@michael-mckinney
Copy link

Issue description

Currently the only supported INT64 DateTimeFormat is for a ConvertedType of TIMESTAMP_MILLIS.

Per https://spark.apache.org/docs/latest/sql-ref-datetime-pattern.html and https://spark.apache.org/docs/3.4.1/configuration.html#runtime-sql-configuration it seems the preference for Spark (ie what underlies DataBricks) is to use Parquet's LogicalType TimestampType(isAdjustedToUTC = true, unit = MICROS) (ie ConvertedType TIMESTAMP_MICROS) as truncation likely occurs when ingesting nanos or exporting millis.

Is it possible to add additional INT64 timestamp support to include MICROS?

@nodakai
Copy link

nodakai commented Jul 8, 2023

I'm willing to add UTC = true, unit = NANOS once MICROS is done

@aloneguid aloneguid added this to the 4.18.0 milestone Nov 16, 2023
@aloneguid aloneguid self-assigned this Nov 16, 2023
@aloneguid aloneguid modified the milestones: 4.18.0, 4.19.0 Dec 22, 2023
@aloneguid aloneguid removed this from the 4.19.0 milestone Jan 5, 2024
@aloneguid aloneguid modified the milestones: 4.20., 4.20.0 Jan 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants