Declare array generated with GENERATE_ARRAY in Bigquery

Question

I am trying to set the values of an ARRAY to the result of GENERATE_ARRAY in Bigquery

DECLARE arr ARRAY <INT64>;
SET arr = (SELECT GENERATE_ARRAY(0,100,10));

But I am getting this error

Query error: Cannot coerce expression (SELECT GENERATE_ARRAY(0,100,10)) to type ARRAY<FLOAT64>

What should I do? Thanks!

gcp · Accepted Answer · 2021-08-27 09:46:35Z

1

The answer is

DECLARE arr ARRAY <INT64>;
SET arr = GENERATE_ARRAY(0,100,10);

answered Aug 27, 2021 at 9:46

gcp

414 bronze badges

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

1 Answer 1