versioned_docs/version-2.0/sql-manual/sql-functions/map-functions/map.md

---
{
    "title": "MAP",
    "language": "en"
}
---

### Description

#### Syntax

`MAP<K, V> map(K key0, V value0, K key1, V value1, ..., K keyn, V valuen)`

Construct a type-specific `Map<K, V>` using a set of key-value pairs.

### Example

```sql
mysql> select map(1, "100", 0.1, 2);
+---------------------------------------------------------------------------------------+
| map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)) |
+---------------------------------------------------------------------------------------+
| {1.0:"100", 0.1:"2"}                                                                  |
+---------------------------------------------------------------------------------------+
1 row in set (0.16 sec)

mysql> select map(1, "100", 0.1, 2)[1];
+-------------------------------------------------------------------------------------------------------------------------------+
| element_at(map(cast(1 as DECIMALV3(2, 1)), '100', cast(0.1 as DECIMALV3(2, 1)), cast(2 as TEXT)), cast(1 as DECIMALV3(2, 1))) |
+-------------------------------------------------------------------------------------------------------------------------------+
| 100                                                                                                                           |
+-------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.16 sec)
```

### Keywords

MAP