You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Jia-Xuan Liu (Jira)" <ji...@apache.org> on 2022/08/25 16:25:00 UTC

[jira] [Created] (CALCITE-5245) Array element accessing in BigQuery should invoke `ORDINAL` operator

Jia-Xuan Liu created CALCITE-5245:
-------------------------------------

             Summary: Array element accessing in BigQuery should invoke `ORDINAL` operator
                 Key: CALCITE-5245
                 URL: https://issues.apache.org/jira/browse/CALCITE-5245
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.31.0
            Reporter: Jia-Xuan Liu


Access an element of array in BigQuery should invoke `ORDINAL`(1-based) or `OFFSET`(0-based) operator for the index. See [BigQuery Accessing array elements|https://cloud.google.com/bigquery/docs/reference/standard-sql/arrays#accessing_array_elements].

For example:
{code:sql}
SELECT ARRAY[1,2,3][ORDINAL(1)]
{code}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)