feat: Implement datafusion-spark sequence function #20540
Description
Is your feature request related to a problem or challenge?
Ref EPIC: #15914
datafusion-spark submodule needs sequence function support by enabling sequence.slt:
Case1: Natural order:
query ?
SELECT sequence(1, 5);
----
[1, 2, 3, 4, 5]
Case2: Reverse order:
query ?
SELECT sequence(5, 1);
----
[5, 4, 3, 2, 1]
Case3: Date / Timestamp with interval
SELECT sequence(DATE '1992-01-01', DATE '1992-01-03', INTERVAL '6' HOUR)
SELECT sequence(TIMESTAMP '2023-01-01T00:00:00', TIMESTAMP '2023-01-01T00:00:00', INTERVAL '1' DAY)
Ref: https://docs.databricks.com/aws/en/sql/language-manual/functions/sequence
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response