Adding a column to a table
In this guide, we'll learn how to add a column to an existing table.
· 阅读需 4 分钟
Knowledge Base
7 篇博文 包含标签Data Modelling
How to filter a ClickHouse table by an array-column?
Knowledgebase article on how to filter a ClickHouse table by an array-column.
· 阅读需 3 分钟
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 分钟
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 分钟
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.
· 阅读需 1 分钟
Are Materialized Views inserted synchronously?
This KB article explores whether Materialized Views are inserted synchronously
· 阅读需 2 分钟
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 分钟