[jira] [Commented] (SPARK-23927) High-order function: sequence

["Alex Wajda (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-23927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16433926#comment-16433926 ] 

Alex Wajda commented on SPARK-23927:
------------------------------------

I will take this one.
Thanks.

> High-order function: sequence
> -----------------------------
>
>                 Key: SPARK-23927
>                 URL: https://issues.apache.org/jira/browse/SPARK-23927
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 2.3.0
>            Reporter: Xiao Li
>            Priority: Major
>
> Ref: https://prestodb.io/docs/current/functions/array.html
> * sequence(start, stop) → array<bigint>
> Generate a sequence of integers from start to stop, incrementing by 1 if start is less than or equal to stop, otherwise -1.
> * sequence(start, stop, step) → array<bigint>
> Generate a sequence of integers from start to stop, incrementing by step.
> * sequence(start, stop) → array<date>
> Generate a sequence of dates from start date to stop date, incrementing by 1 day if start date is less than or equal to stop date, otherwise -1 day.
> * sequence(start, stop, step) → array<date>
> Generate a sequence of dates from start to stop, incrementing by step. The type of step can be either INTERVAL DAY TO SECOND or INTERVAL YEAR TO MONTH.
> * sequence(start, stop, step) → array<timestamp>
> Generate a sequence of timestamps from start to stop, incrementing by step. The type of step can be either INTERVAL DAY TO SECOND or INTERVAL YEAR TO MONTH.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org