【Presto】数组函数

weixin_39430512

已于 2022-07-04 18:36:05 修改

阅读量483

点赞数

分类专栏： Presto 文章标签：大数据 big data sql

于 2022-05-16 12:14:44 首次发布

本文链接：https://blog.csdn.net/weixin_39430512/article/details/124747488

版权

Presto 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

sequence

sequence(start, stop)

sequence(bigint,bigint) -> array[bigint]
sequence(date,date) -> array[date]

select sequence(1,5)
-- [1,2,3,4,5]
select sequence(date('2022-05-16'),date('2022-05-17'))
-- [2022-05-16, 2022-05-17]

sequence(start,stop,step)

sequence(bigint, bigint, bigint) -> array[bigint]
sequence(date, date, interval day to second) -> array[date]
sequence(date, date, interval year to month) -> array[date]
sequence(timestamp, timestamp, interval day to second) -> array[timestamp]
sequence(timestamp, timestamp, interval year to month) -> array[timestamp]

select sequence(1,10,3)
-- [1, 4, 7, 10]
select sequence(date('2022-05-16'),date('2022-05-25'),interval '2' day)
-- [2022-05-16, 2022-05-18, 2022-05-20, 2022-05-22, 2022-05-24]
select sequence(date('2022-05-16'),date('2022-07-25'),interval '2' month)
-- [2022-05-16, 2022-07-16]
select sequence(cast('2022-05-16 12:00:00' as timestamp),cast('2022-05-16 12:00:30' as timestamp),interval '7' second)
-- [2022-05-16 12:00:00.000, 2022-05-16 12:00:07.000, 2022-05-16 12:00:14.000, 2022-05-16 12:00:21.000, 2022-05-16 12:00:28.000]
select sequence(cast('2022-05-16 12:00:00' as timestamp),cast('2022-05-18 12:00:30' as timestamp),interval '1' day)
-- [2022-05-16 12:00:00.000, 2022-05-17 12:00:00.000, 2022-05-18 12:00:00.000]
select sequence(cast('2022-05-16 12:00:00' as timestamp),cast('2022-07-18 12:00:30' as timestamp),interval '1' month)
-- [2022-05-16 12:00:00.000, 2022-06-16 12:00:00.000, 2022-07-16 12:00:00.000]