Switch to parquet. Use WRITE ORDERED BY. (!21) · Merge requests · repos / data-engineering / dumps / mediawiki-content-dump · GitLab

How to register an account on GitLab. Due to spam, new accounts are locked until approved by an admin or the approver bot. Your GitLab account gets automatically approved within one hour if you are a member of Trusted Contributors in Gerrit, or a member of the Trusted-Contributors group in Phabricator and linked your Developer account to your Phabricator account. If none of these apply, you can file an unlock request to expedite access.

Support: mw:GitLab, how to host a project on GitLab, #wikimedia-gitlab on libera.chat, #GitLab on Phabricator.

🚨THIS IS A REPLICA🚨 -- You probably want to use the production gitlab, https://gitlab.wikimedia.org. Data on this instance is likely to be overwritten at short notice. Login with hardware 2FA key does not work, please use one-time passwords.

Xcollazo requested to merge move-to-parquet into main Dec 14, 2023

Modify DDL so that we use parquet, to leverage its footer statistics. Additionally, make sure that we WRITE ORDERED BY so that the parquet files are globally sorted. This helps tremendously at query planning to discard files.

Bug: T340863