presto 数组拆成行

字符串转行

select str_days
FROM (
SELECT array_join(sequence(date('2022-02-01'),date('2022-02-11')),',') str_date
)
CROSS JOIN UNNEST(split(str_date,',')) AS t (str_days)

 

 

 

 

 

 

数组转行

1 select days
2 FROM (SELECT sequence(date('2022-02-01'),date('2022-02-21')) AS  arr_days )
3 CROSS JOIN UNNEST(arr_days) AS t (days)

 

posted @ 2022-02-22 19:12  linbo.yang  阅读(496)  评论(0)  编辑  收藏  举报