ClickHouse How-To Guides

Practical ClickHouse answers with statements you can copy and run.

• How to Create a Table in ClickHouse
• How to Insert Data in ClickHouse
• How to Update Rows in ClickHouse
• How to Delete Rows in ClickHouse
• How to Rename a Table in ClickHouse
• How to Add a Column in ClickHouse
• How to Drop a Column in ClickHouse
• How to Change a Column Type in ClickHouse
• How to Create a View in ClickHouse
• How to Create a Materialized View in ClickHouse
• How to List Tables in ClickHouse
• How to Describe a Table in ClickHouse
• How to Duplicate a Table in ClickHouse
• How to Truncate a Table in ClickHouse
• How to Deduplicate Data in ClickHouse
• How to Upsert in ClickHouse
• How to Get the Current Date and Time in ClickHouse
• How to Work with Dates in ClickHouse
• How to Use Array Functions in ClickHouse
• How to Use groupArray in ClickHouse
• How to Kill a Query in ClickHouse
• How to Check Table Sizes in ClickHouse
• How to Create a Database in ClickHouse
• How to Drop a Partition in ClickHouse
• How to Use TTL in ClickHouse

Running ClickHouse queries as a team? See the SaturnSQL ClickHouse editor.