Adding a column to a table
In this guide, we'll learn how to add a column to an existing table.
· 약 4분
Knowledge Base
"Data Modelling" 태그로 연결된 7개 게시물개의 게시물이 있습니다.
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분
