hyper: a Parquet file with a footer over 16 MiB is refused

Ouverte
#3,291 1 commentaire 0 réactions 0 personnes assignées Voir sur GitHub

Les mainteneurs répondent en général sous 1 jour

Personne n'a encore pris cette issue.

Évaluation

Difficulté
4/5
Temps estimé
3-5 jours
Accessibilité débutants
15/100
Type d'issue
Bug
Clarté
Clairement spécifiée
Activité
Active
Stack technique
shell
Domaine
databases

Piste de recherche

The failure comes from the Hyper engine's Parquet reader, not from the ClickBench scripts, so the scripts under hyper/load only show how the file is loaded. Start with the reproduction: write hits-small-groups.parquet with the ClickHouse command in the issue, then load it with hyper/load and confirm the 16777216-byte footer error. Done would mean the load succeeds, or the limit becomes configurable and hyper/load sets it. Because the limit is inside Hyper, the fix needs upstream engine changes and maintainer input.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Description

Hyper refuses a Parquet file whose footer is larger than 16 MiB:

tableauhyperapi.hyperexception.HyperException: error while reading Parquet file: Error in hits.parquet
	The footer size 35231477 of the Parquet file exceeds the maximum allowed footer size which is 16777216

This happened in the randomized benchmark (https://github.com/ClickHouse/ClickBench/pull/3271), which loads a generated dataset of a billion rows with the same schema as hits.parquet, using hyper/load unchanged. The file was written by ClickHouse 26.10 with its default row group size limit of 512 MB, which gives more than a thousand row groups for a billion rows, and their metadata makes a footer of 35 MB. The Parquet format has no such limit, and the other systems of the benchmark (ClickHouse, DuckDB, Firebolt, PostgreSQL-based ones, and others) loaded the same file.

Reproduction with the standard dataset: rewriting hits.parquet (100M rows, 226 row groups, a footer of 2.4 MB) with smaller row groups gives 2360 row groups and a footer of 31.6 MB:

clickhouse local --output_format_parquet_row_group_size 40000 --output_format_parquet_row_group_size_bytes 100000000000 \
    --query "SELECT * FROM file('hits.parquet') INTO OUTFILE 'hits-small-groups.parquet' TRUNCATE FORMAT Parquet"
clickhouse local --query "SELECT num_row_groups, metadata_size FROM file('hits-small-groups.parquet', ParquetMetadata)"
# 2360	31626081

Loading hits-small-groups.parquet with hyper/load should fail with the same message.

Could the limit be raised (or made configurable through an option that hyper/load could set)? The randomized benchmark now writes about 250 row groups per file, as the original file has, so its next runs avoid the limit, but files with many row groups are common for large datasets.

Hyper API version in the run: tableauhyperapi 0.0.26963 (hyper/install of main on 2026-11-13), machine c6a.metal.

@caetanosauer @vogelsgesang

🤖 Generated with Claude Code

Langage dominant
Shell
Étoiles
1.2k
Forks
334
Merge moyen
3 h 50 min
PR mergées (30 j)
710

Préparer son environnement

  • Aucun Dockerfile ni fichier Docker Compose
  • Propose un modèle de pull request
  • Aucun guide de contribution

Par où commencer

  1. Lisez l'issue en entier, puis le guide de contribution du projet.
  2. Signalez en commentaire que vous la prenez — cela évite que deux personnes fassent le même travail.
  3. Forkez le dépôt et travaillez sur une branche.
  4. Ouvrez une pull request qui référence le numéro de l'issue.

Autres issues de ClickHouse/ClickBench

Toutes les issues de ClickHouse/ClickBench

Issues similaires

Plus d'issues Shell/Bash

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.