[
https://issues.apache.org/jira/browse/FLINK-32720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanyu Zheng updated FLINK-32720:
--------------------------------
Description:
GENERATE_SERIES Function
Description
Constructs an array of values between {{start}} and {{{}end{}}}, inclusive.
Parameters {{start}} and {{end}} can be an {{INT}} or {{{}BIGINT{}}}.
{{{}step{}}}, if supplied, specifies the step size. The step can be positive or
negative. If not supplied, {{step}} defaults to {{{}1{}}}. Parameter {{step}}
must be an {{{}INT{}}}.
Syntax
The syntax for the GENERATE_SERIES function is:
{code:java}
GENERATE_SERIES(start, end)
GENERATE_SERIES(start, end, step){code}
Example
Let's look at some function examples and explore how to use the SPLIT function.
For example:
{code:java}
SELECT GENERATE_SERISE(1, 5);
Result: [1,2,3,4,5]
SELECT GENERATE_SERISE(0, 10, 2);
Result: [0, 2, 4, 6, 8, 10] {code}
see also:
1.PostgreSQL: PostgreSQL offers a function called {{generate_series}} which
generates a set of contiguous integers from a start to an end value. An
optional 'step' parameter is available to specify the increment between each
integer.
https://www.postgresql.org/docs/current/functions-srf.html
2.ksqlDB: As you mentioned, ksqlDB provides a function called
{{GENERATE_SERIES}} that generates a series of numbers, starting from a given
start value, incrementing each time by a step value, until it reaches or
exceeds a given end value.
https://docs.ksqldb.io/en/latest/developer-guide/ksqldb-reference/scalar-functions/#generate_series
3.BigQuery: BigQuery has a function called {{GENERATE_ARRAY}} that generates an
array consisting of integers from the start value to the end value, with each
integer incremented by the step value. You can find more details in the
https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_array
was:
GENERATE_SERIES Function
Description
Constructs an array of values between {{start}} and {{{}end{}}}, inclusive.
Parameters {{start}} and {{end}} can be an {{INT}} or {{{}BIGINT{}}}.
{{{}step{}}}, if supplied, specifies the step size. The step can be positive or
negative. If not supplied, {{step}} defaults to {{{}1{}}}. Parameter {{step}}
must be an {{{}INT{}}}.
Syntax
The syntax for the GENERATE_SERIES function is:
{code:java}
GENERATE_SERIES(start, end)
GENERATE_SERIES(start, end, step){code}
Example
Let's look at some function examples and explore how to use the SPLIT function.
For example:
{code:java}
SELECT GENERATE_SERISE(1, 5);
Result: [1,2,3,4,5]
SELECT GENERATE_SERISE(0, 10, 2);
Result: [0, 2, 4, 6, 8, 10] {code}
see also:
> Add GENERATE_SERIES support in SQL & Table API
> ----------------------------------------------
>
> Key: FLINK-32720
> URL: https://issues.apache.org/jira/browse/FLINK-32720
> Project: Flink
> Issue Type: Improvement
> Reporter: Hanyu Zheng
> Priority: Major
>
> GENERATE_SERIES Function
> Description
> Constructs an array of values between {{start}} and {{{}end{}}}, inclusive.
> Parameters {{start}} and {{end}} can be an {{INT}} or {{{}BIGINT{}}}.
> {{{}step{}}}, if supplied, specifies the step size. The step can be positive
> or negative. If not supplied, {{step}} defaults to {{{}1{}}}. Parameter
> {{step}} must be an {{{}INT{}}}.
> Syntax
> The syntax for the GENERATE_SERIES function is:
> {code:java}
> GENERATE_SERIES(start, end)
> GENERATE_SERIES(start, end, step){code}
>
> Example
> Let's look at some function examples and explore how to use the SPLIT
> function.
> For example:
>
> {code:java}
> SELECT GENERATE_SERISE(1, 5);
> Result: [1,2,3,4,5]
> SELECT GENERATE_SERISE(0, 10, 2);
> Result: [0, 2, 4, 6, 8, 10] {code}
> see also:
> 1.PostgreSQL: PostgreSQL offers a function called {{generate_series}} which
> generates a set of contiguous integers from a start to an end value. An
> optional 'step' parameter is available to specify the increment between each
> integer.
> https://www.postgresql.org/docs/current/functions-srf.html
> 2.ksqlDB: As you mentioned, ksqlDB provides a function called
> {{GENERATE_SERIES}} that generates a series of numbers, starting from a given
> start value, incrementing each time by a step value, until it reaches or
> exceeds a given end value.
> https://docs.ksqldb.io/en/latest/developer-guide/ksqldb-reference/scalar-functions/#generate_series
> 3.BigQuery: BigQuery has a function called {{GENERATE_ARRAY}} that generates
> an array consisting of integers from the start value to the end value, with
> each integer incremented by the step value. You can find more details in the
> https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_array
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
