v.21.1Experimental Features

Add Support for Map Data Type with String Keys and Values

Official CH changelog text
Add new data type Map. See #1841. First version for Map only supports String type of key and value. #15806 (hexiaoting).
Introduces a new Map data type in ClickHouse, initially supporting key and value types of String.

Why it matters

To enable users to store and query key-value pairs directly within ClickHouse tables, enhancing the expressiveness and flexibility of data schemas by supporting map structures.

How to use it

Define columns with the Map(String, String) data type in your table schema. Use standard SQL operations to insert, query, and manipulate map data within ClickHouse.

Related resources

PreviousNext