Adding a column to a table
· 4 min read
In this guide, we'll learn how to add a column to an existing table.
7 posts tagged with "Data Modelling"
View All TagsHow to filter a ClickHouse table by an array-column?
· 3 min read
Knowledgebase article on how to filter a ClickHouse table by an array-column.
Can you PIVOT in ClickHouse?
· 7 min read
ClickHouse doesn't have a PIVOT clause, but we can get close to this functionality using aggregate function combinators. Let's see how to do this using the UK housing prices dataset.
Why can't I see my data in a dictionary in ClickHouse Cloud?
· 2 min read
There is an issue where data in dictionaries may not be visible immediately after creation.
How to Create a ClickHouse Dictionary with String Keys and Values
· One min read
Learn how to create a ClickHouse dictionary using string keys and values from a MergeTree table as the source, with examples of setup and usage.
Are Materialized Views inserted synchronously?
· 2 min read
This KB article explores whether Materialized Views are inserted synchronously
How to confirm if a Projection is used by the query?
· 2 min read
Learn how to check if a projection is used in ClickHouse queries by testing with sample data and using EXPLAIN to verify projection usage.