select
cast(split(concat(column1, ',', column2, ',',column3), ',') as array<bigint>)
as long_list_column
from
the_table
select
cast(split(concat(column1, ',', column2, ',',column3), ',') as array<bigint>)
as long_list_column
from
the_table