[
https://issues.apache.org/jira/browse/CALCITE-7448?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18071733#comment-18071733
]
Caican Cai commented on CALCITE-7448:
-------------------------------------
[~tmate] Thanks for the update. I'll take a look at it over the next couple of
days; if there are any points of contention, I may reach out via email to
discuss them.
I believe this is a very useful feature, so I will be actively pushing it
forward.
> Support colon-based field/item access syntax
> --------------------------------------------
>
> Key: CALCITE-7448
> URL: https://issues.apache.org/jira/browse/CALCITE-7448
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Affects Versions: 1.41.0
> Reporter: Tamas Mate
> Priority: Major
> Labels: parser, pull-request-available
>
> Implement support for colon field access syntax in the parser, for example:
> {code:java}
> v:field
> v:field.subfield
> v:['field name']
> arr[1]:field{code}
> Several systems (e.g. Snowflake, Databricks) support this kind of access, and
> with recent VARIANT support in Parquet it seems increasingly relevant for
> interoperability.
> * [Databricks - :: (colon colon sign)
> operator|https://docs.databricks.com/aws/en/sql/language-manual/functions/coloncolonsign]
> * [Databricks - : (colon sign)
> operator|https://docs.databricks.com/aws/en/sql/language-manual/functions/colonsign]
> * [Snowflake - ::
> operator|https://docs.snowflake.com/en/sql-reference/data-types-semistructured#using-variant-values]
> * [Snowflake - : Dot
> Notation|https://docs.snowflake.com/en/user-guide/querying-semistructured#label-querying-semistructured-data-dot-notation]
> One challenge is that ":" is already used in JSON constructor syntax, for
> example:
> {code:java}
> JSON_OBJECT('k': v)
> JSON_OBJECTAGG(k: v){code}
> The implementation needs to define how these cases interact, whether through
> disambiguation, dialect-specific behavior, or parser configuration.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
