[ARROW-15855] [Python] Add dictionary_pagesize_limit to Parquet writer

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Parquet, Python
• External issue URL: https://github.com/apache/arrow/issues/31292
• Assignee: Unassigned
• Reporter: Xinyu Zeng
• Created: 07/Mar/22 11:05
• Updated: 11/Jan/23 11:40
• Resolved: 08/Mar/22 16:04

Description

Although the python Parquet api is a wrapper of C++, there are some tuning knobs not included in python. For example, dictionary_pagesize_limit_. The dictionary page size will easily exceed the limit when any or many of the followings happen: 1. The row_group_size is relatively large e.g. the default is 64M. 2. The size per entry is large e.g large string column 3. the repeatability of data is not so high. This may result in the dictionary encoding not being fully utilized if this parameter cannot be tuned. In C++, however, this parameter can be tuned to the optimized setting.

 

There are also other parameters not exposed in python, for example, max_statistics_size.

Issue Links

• is duplicated by: ARROW-7174 [Python] Expose parquet dictionary size write parameter in python.