Skip to content

EXPORT PART sometimes doesnt preserve ordering in output Parquet file #1135

@dima-altinity

Description

@dima-altinity

Following statement was used to export part.

ALTER TABLE <tbl_name> EXPORT PART '20251016-365_0_807_4' TO TABLE <tbl_name_export>
settings allow_experimental_export_merge_tree_part=1, export_merge_tree_part_overwrite_file_if_exists=1,output_format_parquet_parallel_encoding=0, output_format_parallel_formatting=0;

<tbl_name> uses 5 fields in ORDER BY. Output Parquet file has several rows that are out of order.

It happened just for 1 part out of 600 that were exported so it seems that issue depends on data.

Expected behavior
All rows in Parquet file should be sorted according to columns in ORDER BY<tbl_name>

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions