ARRAY_COUNT

统计数组中非 NULL 元素的个数。

语法

ARRAY_COUNT(<array>)

返回类型

BIGINT

示例

SELECT ARRAY_COUNT([1, 2, 3]) AS cnt;

+-----+
| cnt |
+-----+
|   3 |
+-----+

SELECT ARRAY_COUNT([1, NULL, 3]) AS cnt_with_null;

+----------------+
| cnt_with_null  |
+----------------+
|              2 |
+----------------+

SELECT ARRAY_COUNT(['a', 'b', NULL]) AS cnt_text;

+----------+
| cnt_text |
+----------+
|        2 |
+----------+