cardinality()

Returns the size of the map (or the number of entries in the map)

Arguments & returns

Scalar

Overload link	`map`	… Varargs	Returns
#01	`ANY`	`ANY`	`UBIGINT`

… accepts a variable number of arguments of the type shown.

SELECT cardinality( map([4, 2], ['a', 'b']) );

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT id, MAP_SIZE(attrs) AS attr_count FROM demo_maps

In DuckDB

SELECT id, CARDINALITY(attrs) AS attr_count FROM demo_maps