You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Weston Pace (Jira)" <ji...@apache.org> on 2021/02/17 19:54:00 UTC
[jira] [Commented] (ARROW-11678) [python] Broken round-trip with
ParquetWriter.write_table -> read_table -> ParquetWriter.write_table
[ https://issues.apache.org/jira/browse/ARROW-11678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17286116#comment-17286116 ]
Weston Pace commented on ARROW-11678:
-------------------------------------
Parquet version 1 did not have support to fit the entire uint32 range so it upcasts to int64. See ARROW-436.
This is expected behavior. If you specify version="2.0" it should round trip correctly.
{code:java}
pq.ParquetWriter('test_metadata.parquet', schema, version='2.0')
{code}
> [python] Broken round-trip with ParquetWriter.write_table -> read_table -> ParquetWriter.write_table
> ----------------------------------------------------------------------------------------------------
>
> Key: ARROW-11678
> URL: https://issues.apache.org/jira/browse/ARROW-11678
> Project: Apache Arrow
> Issue Type: Bug
> Components: Python
> Affects Versions: 3.0.0
> Reporter: ARF
> Priority: Critical
>
> Round-tripping with ParquetWriter.write_table() -> pyarrow.parquet.read_table() -> ParquetWriter.write_table() is broken:
>
> {color:#af00db}import{color}{color:#000000} {color}{color:#267f99}pyarrow{color}{color:#000000} {color}{color:#af00db}as{color}{color:#000000} {color}{color:#267f99}pa{color}
> {color:#af00db}import{color}{color:#000000} {color}{color:#267f99}pyarrow{color}{color:#000000}.{color}{color:#267f99}parquet{color}{color:#000000} {color}{color:#af00db}as{color}{color:#000000} {color}{color:#267f99}pq{color}
> {color:#001080}schema{color}{color:#000000} = {color}{color:#267f99}pa{color}{color:#000000}.schema({{color}
> {color:#000000} {color}{color:#a31515}'code'{color}{color:#000000}: {color}{color:#267f99}pa{color}{color:#000000}.uint32(),{color}
> })
> with{color:#000000} {color}{color:#267f99}pq{color}{color:#000000}.{color}{color:#267f99}ParquetWriter{color}{color:#000000}({color}{color:#a31515}'test_metadata.parquet'{color}{color:#000000}, {color}{color:#001080}schema{color}{color:#000000}) {color}{color:#af00db}as{color}{color:#000000} {color}{color:#001080}pqwriter{color}{color:#000000}:{color}
> {color:#000000} {color}{color:#001080}code{color}{color:#000000} = {color}{color:#098658}111000{color}
> {color:#000000} {color}{color:#001080}table{color}{color:#000000} = {color}{color:#267f99}pa{color}{color:#000000}.Table.from_pydict({{color}
> {color:#000000} {color}{color:#a31515}'code'{color}{color:#000000}: {color}{color:#267f99}pa{color}{color:#000000}.nulls({color}{color:#098658}10{color}{color:#000000}, {color}{color:#001080}schema{color}{color:#000000}.field({color}{color:#a31515}'code'{color}{color:#000000}).type).fill_null({color}{color:#001080}code{color}{color:#000000}),{color}
> {color:#000000} }){color}
> {color:#000000} {color}{color:#001080}pqwriter{color}{color:#000000}.{color}{color:#795e26}write_table{color}{color:#000000}({color}{color:#001080}table{color}{color:#000000}){color}
> {color:#001080}existing_table{color}{color:#000000} = {color}{color:#267f99}pq{color}{color:#000000}.{color}{color:#795e26}read_table{color}{color:#000000}({color}{color:#a31515}'test_metadata.parquet'{color}{color:#000000}){color}
> {color:#af00db}with{color}{color:#000000} {color}{color:#267f99}pq{color}{color:#000000}.{color}{color:#267f99}ParquetWriter{color}{color:#000000}({color}{color:#a31515}'test_metadata.parquet'{color}{color:#000000}, {color}{color:#001080}schema{color}{color:#000000}) {color}{color:#af00db}as{color}{color:#000000} {color}{color:#001080}pqwriter{color}{color:#000000}:{color}
> {color:#000000} {color}{color:#001080}pqwriter{color}{color:#000000}.{color}{color:#795e26}write_table{color}{color:#000000}({color}{color:#001080}existing_table{color}{color:#000000}){color}
>
>
> ----
> *Error Message:*
> ValueError: Table schema does not match schema used to create file:
> table:
> code: int64
> -- field metadata --
> PARQUET:field_id: '1' vs.
> file:
> code: uint32
--
This message was sent by Atlassian Jira
(v8.3.4#803005)