Finding length of array from a Array

Question

I have array field as give below in a column call emailed_user

[[email protected],[email protected],[email protected],[email protected]]

I want to find number of element in the array.

I have written the code for the above ARRAY_LENGTH(SPLIT(emailed_users),",") as Number_of_items2

I am getting error No matching signature for function SPLIT for argument types: ARRAY. Supported signatures: SPLIT(STRING, [STRING]); SPLIT(BYTES, BYTES) Could you please help me. Answer can be given in standardsql I am using Googlesql

Mikhail Berlyant · Accepted Answer · 2019-12-16 17:56:18Z

1

You should use below

ARRAY_LENGTH(emailed_users) as Number_of_items2

As you can see - you don't need SPLIT because your emailed_users field is already of type ARRAY

Quick test below

#standardSQL
WITH `project.dataset.table` AS (
  SELECT ['[email protected]','[email protected]','[email protected]','[email protected]'] emailed_users
)
SELECT ARRAY_LENGTH(emailed_users) AS Number_of_items2  
FROM `project.dataset.table`

with result

Row Number_of_items2     
1   4

answered Dec 16, 2019 at 17:56

Mikhail Berlyant

174k10 gold badges173 silver badges251 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Finding length of array from a Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related