Adding a column to a table
In this guide, we'll learn how to add a column to an existing table.
· 4 min read
7 posts tagged with "Data Modelling"
View All TagsHow to filter a ClickHouse table by an array-column?
Knowledgebase article on how to filter a ClickHouse table by an array-column.
· 3 min read
Can you PIVOT in ClickHouse?
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.
· 7 min read
Why can't I see my data in a dictionary in ClickHouse Cloud?
There is an issue where data in dictionaries may not be visible immediately after creation.
· 2 min read
How to Create a ClickHouse Dictionary with String Keys and Values
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.
· One min read
Are Materialized Views inserted synchronously?
This KB article explores whether Materialized Views are inserted synchronously
· 2 min read
How to confirm if a Projection is used by the query?
Learn how to check if a projection is used in ClickHouse queries by testing with sample data and using EXPLAIN to verify projection usage.
· 2 min read