[jira] [Commented] (ARROW-5888) [Python][C++] Add metadata to store Arrow time zones in Parquet file metadata

["Joris Van den Bossche (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARROW-5888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16909131#comment-16909131 ] 

Joris Van den Bossche commented on ARROW-5888:
----------------------------------------------

This should now also be possible with the full schema being stored in the parquet metadata?

> [Python][C++] Add metadata to store Arrow time zones in Parquet file metadata
> -----------------------------------------------------------------------------
>
>                 Key: ARROW-5888
>                 URL: https://issues.apache.org/jira/browse/ARROW-5888
>             Project: Apache Arrow
>          Issue Type: Improvement
>          Components: C++, Python
>            Reporter: Florian Jetter
>            Priority: Minor
>              Labels: parquet
>             Fix For: 1.0.0
>
>
> The timezone is not roundtrip safe for timezones other than UTC when storing to parquet. Expected behavior would be that the timezone is properly reconstructed
> {code:python}
> schema = pa.schema(
>     [
>         pa.field("no_tz", pa.timestamp('us')),
>         pa.field("no_tz", pa.timestamp('us', tz="UTC")),
>         pa.field("no_tz", pa.timestamp('us', tz="Europe/Berlin")),
> ]
> )
> buf = pa.BufferOutputStream()
> pq.write_metadata(
>     schema,
>     buf,
>     coerce_timestamps="us"
> )
> pq_bytes = buf.getvalue().to_pybytes()
> reader = pa.BufferReader(pq_bytes)
> parquet_file = pq.ParquetFile(reader)
> parquet_file.schema.to_arrow_schema()
> # Output:
> # no_tz: timestamp[us]
> # utc: timestamp[us, tz=UTC]
> # europe: timestamp[us, tz=UTC]
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)