Skip to content

Conversation

mariusandra
Copy link
Collaborator

Problem

We used to rely on some ClickHouse hacks to materialize columns. Materialization would affect only a backfill amount of days, because we'd have to rewrite/optimize all columns.

Changes

ClickHouse has since then added a new ALTER TABLE .. MATERIALIZE COLUMN syntax, which should do the backfill automatically for any parts that are missing a column.

How did you test this code?

Didn't test it yet. Putting it out there for criticisim.

@posthog-bot
Copy link
Contributor

This PR hasn't seen activity in a week! Should it be merged, closed, or further worked on? If you want to keep it open, post a comment or remove the stale label – otherwise this will be closed in another week.

@posthog-bot
Copy link
Contributor

This PR hasn't seen activity in a week! Should it be merged, closed, or further worked on? If you want to keep it open, post a comment or remove the stale label – otherwise this will be closed in another week.

@posthog-bot
Copy link
Contributor

This PR hasn't seen activity in a week! Should it be merged, closed, or further worked on? If you want to keep it open, post a comment or remove the stale label – otherwise this will be closed in another week.

@mariusandra
Copy link
Collaborator Author

I'm going to close this PR, as it's gotten stale. This materialization issue will come back though...

@mariusandra mariusandra deleted the speed-up-materialization branch June 15, 2023 13:06
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants