Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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:
GENERATE_SERIES(start, end) GENERATE_SERIES(start, end, step)
Example
Let's look at some function examples and explore how to use the SPLIT function.
For example:
SELECT GENERATE_SERISE(1, 5); Result: [1,2,3,4,5] SELECT GENERATE_SERISE(0, 10, 2); Result: [0, 2, 4, 6, 8, 10]
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