[CALCITE-4822] Add ARRAY_CONCAT, ARRAY_REVERSE, ARRAY_LENGTH for BigQuery dialect

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.29.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Sergey Nuyanzin
• Created: 03/Oct/21 10:38
• Updated: 04/Jan/22 08:27
• Resolved: 04/Jan/22 08:27

Description

ARRAY_CONCAT - Concatenates one or more arrays with the same element type into a single array.
ARRAY_LENGTH - Returns the size of the array. Synonym for CARDINALITY.
ARRAY_REVERSE - Returns the input ARRAY with elements in reverse order.

For more details
https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_concat
https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_length
https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_reverse

Issue Links

• links to: GitHub Pull Request #2559