尋找陣列長度 - Amazon Athena

尋找陣列長度

cardinality 函數會傳回陣列的長度,如此範例所示:

SELECT cardinality(ARRAY[1,2,3,4]) AS item_count

此查詢會傳回:

+------------+ | item_count | +------------+ | 4 | +------------+