Jenkins build is back to normal : Calcite » Calcite-snapshots #36

2022-01-03 Thread Apache Jenkins Server
See

[jira] [Created] (CALCITE-4972) Qualify subfields of array columns containing structs in return of getFieldOrigins

2022-01-03 Thread Mark Grey (Jira)
Mark Grey created CALCITE-4972: -- Summary: Qualify subfields of array columns containing structs in return of getFieldOrigins Key: CALCITE-4972 URL: https://issues.apache.org/jira/browse/CALCITE-4972 Proj

Re: Trying to call "PreparedStatement.run()" throws "Cannot invoke "calcite.schema.Schema.getTable(String)" because the return value of "calcite.schema.SchemaPlus.getSubSchema(String)" is null"

2022-01-03 Thread Gavin Ray
Ahhh -- thanks for the code sample Gunnar and the clarification that you can do it two ways Julian. Data-source metadata updates should be infrequent I can try to use a mutex/arc for the global SchemaPlus Think it would be really beneficial to have a single schema tree that can see every data sou

Re: [DISCUSS] SBOM (Software Bill of Materials)

2022-01-03 Thread Gunnar Morling
Hi, Thanks a lot for this, I think trimming down the dependencies of Calcite will be of great help for its adoption. > So, the easiest way to reduce dependencies would be to make certain classes of SQL functions optional (i.e. move them out of core). That sounds like a good idea. > commons-lang

Re: Trying to call "PreparedStatement.run()" throws "Cannot invoke "calcite.schema.Schema.getTable(String)" because the return value of "calcite.schema.SchemaPlus.getSubSchema(String)" is null"

2022-01-03 Thread Julian Hyde
Gunnar’s point is a good one. To make it a little more explicit: if the value of the the “model” parameter starts with “inline:”, the model is just the rest of the string. As to whether you use models or deal with the SchemaPlus API directly. It’s your decision based on how much concurrency con

Re: Trying to call "PreparedStatement.run()" throws "Cannot invoke "calcite.schema.Schema.getTable(String)" because the return value of "calcite.schema.SchemaPlus.getSubSchema(String)" is null"

2022-01-03 Thread Gunnar Morling
Am Mo., 3. Jan. 2022 um 20:44 Uhr schrieb Gavin Ray : > @Stamatis > > Thank you, I actually did not know that! That's useful information to > have =) > > @Julian > > Is it possible to programmatically generate the JSON model? Why I ask is > because part of the functionality I'm trying to mirror is

Re: ANN: Calcite-to-GraphQL project. Auto-generate GQL API's from Calcite sources.

2022-01-03 Thread Gavin Ray
Thanks! > I'm a bit assuming that the end goal is like hasura to avoid resolvers and generate one big "sql" query for the whole graphql query. Yeah -- there are a few benefits to using Calcite, but the biggest one (IMO) is that Calcite can handle planning and executing distributed/"federated" que

Re: Trying to call "PreparedStatement.run()" throws "Cannot invoke "calcite.schema.Schema.getTable(String)" because the return value of "calcite.schema.SchemaPlus.getSubSchema(String)" is null"

2022-01-03 Thread Gavin Ray
@Stamatis Thank you, I actually did not know that! That's useful information to have =) @Julian Is it possible to programmatically generate the JSON model? Why I ask is because part of the functionality I'm trying to mirror is the ability to add data sources dynamically while the app server is r

Re: Trying to call "PreparedStatement.run()" throws "Cannot invoke "calcite.schema.Schema.getTable(String)" because the return value of "calcite.schema.SchemaPlus.getSubSchema(String)" is null"

2022-01-03 Thread Julian Hyde
> Will try to figure out how to manually perform the process of creating a > proper "Connection" object and adding the schemas to it. Generally the best way is to write a JSON model, and then create a connection using ‘jdbc:calcite:…model=...'. For that to work, your component needs to implemen

[REVIEW REQUEST]: Review Request for CALCITE-4901

2022-01-03 Thread Yanjing Wang
Hi community, I request a review on CALCITE-4901( https://github.com/apache/calcite/pull/2665), which fix the RelToSqlConverterTest using RelRoot.rel rather RelRoot.project(), and that the Project shouldn't wrap a select for Sort.

Feature: crud operations to/from json hierarchy with calcite

2022-01-03 Thread Martin Jonsson
Hello all. PostgreSQL has for a while the capability to do crud (create/read/update/delete) operations from/to a json hierarchy. Writing this sql is both painful and verbose but possible. This capability has been increasingly incorporated in the postgres ecosystem to build various dsl -> sql to

Re: ANN: Calcite-to-GraphQL project. Auto-generate GQL API's from Calcite sources.

2022-01-03 Thread Martin Jonsson
Hello Gavin. First of all, thanks for some nice work.  Also interesting that you work for hasura which is a very interesting tool in the postgres ecosystem. I'm a bit assuming that the end goal is like hasura to avoid resolvers and generate one big "sql" query for the whole graphql query. Some q