[jira] [Created] (CALCITE-4885) Fluent test fixtures so that dependent projects can write parser, validator and rules tests

2021-11-11 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4885: Summary: Fluent test fixtures so that dependent projects can write parser, validator and rules tests Key: CALCITE-4885 URL: https://issues.apache.org/jira/browse/CALCITE-4885

Re: Extracting field identifiers (SqlScopedShuttle / SqlValidator)

2021-11-11 Thread Julian Hyde
You shouldn't need to solve this without dealing with SqlScopedShuttle. If the validator does its job (and yes, it uses SqlScopedShuttle to do its job) then all identifiers will be resolved to the objects they reference. If I were you I would start by running SqlValidatorTest.testFieldOrigin in a

feature request / jdbc push-down / off-platform SQL rewrite

2021-11-11 Thread Anthony Krinsky
Newbie question and perhaps feature request, apologies in advance if this is well trod. I've struggled to find a solution to these problems, which one would think are common: 1) Full fidelity push-down to a JDBC adapted, traditional RDBMS, when only that source is involved in a query. Why not

Extracting field identifiers (SqlScopedShuttle / SqlValidator)

2021-11-11 Thread Mark Grey
In my efforts to continue learning about the internals of Calcite, I've been experimenting with applying Calcite's Babel parser to the task of extracting fully qualified field references from a query. The use case here would be to enumerate all the fields of a schema that are "touched" by a given

Re: Snowflake JSON suport

2021-11-11 Thread Julian Hyde
I wasn’t aware of this Snowflake functionality. It looks very nice. First, note that Calcite already has JSON support consistent with the SQL standard. See https://calcite.apache.org/docs/reference.html#json-functions . If we were

Snowflake JSON suport

2021-11-11 Thread simon . schenk
Hi, I'm experimenting with a dialect for Snowflake. In particular I would like to be able to parse Snowflake JSON expressions, which work on VARIANT columns as follows: Give a JSON structure like this: { "fullName": "Johnny Appleseed", "phoneNumber": { "areaCode": "415",

PR review request(CALCITE-4868)

2021-11-11 Thread Zhe Hu
Hi team, This PR is about supporting sorting aggregation results in Elasticsearch Adapter, please help review it in your free time. Thanks a lot! What’s more, the git workflow shows “First-time contributors need a maintainer to approve running workflows”, awaiting approval?