Re: RECURSIVE keyword not supported?

2023-02-22 Thread Gunnar Morling
t; > > > Best, > > Ruben > > > > [1] https://github.com/apache/calcite/blob/main/site/_docs/algebra.md > > > > > > On Wed, Feb 22, 2023 at 7:32 AM Gunnar Morling > > wrote: > > > > > Hey Julien, > > > > > > Am Di., 21

Re: RECURSIVE keyword not supported?

2023-02-21 Thread Gunnar Morling
o help clarify that fact in the doc (as much as I'd love help building the actual feature, it's just beyond the scope of what my time currently allows for, unfortunately). I think that hardly qualifies as "complaining". Best, --Gunnar Julian > > On Tue, Feb 21, 2023 at

Re: RECURSIVE keyword not supported?

2023-02-21 Thread Gunnar Morling
st regards, > Ruben > > [1] https://issues.apache.org/jira/browse/CALCITE-129 > > > On Tue, Feb 21, 2023 at 7:23 PM Gunnar Morling > wrote: > > > Hi, > > > > I'm trying to run the recursive example from the Calcite algebra docs > [1], > > but I'

RECURSIVE keyword not supported?

2023-02-21 Thread Gunnar Morling
Hi, I'm trying to run the recursive example from the Calcite algebra docs [1], but I'm always getting an error at the RECURSIVE keyword: WITH RECURSIVE aux(i) AS ( VALUES (1) UNION ALL SELECT i+1 FROM aux WHERE i < 10 ) SELECT * FROM aux "Incorrect syntax near

Visualizing Calcite data in Apache Superset

2022-01-30 Thread Gunnar Morling
Hey all, I'm looking into ways of visualizing data provided via Calcite using Apache Superset. For this, I think I'd have to expose some sort of endpoint which Superset can connect to, potentially implementing an existing wire protocol, such as the one of Postgres. That way, Superset could

Re: Extend parser.jj in calcite, to support the operator '<=>'

2022-01-07 Thread Gunnar Morling
> We’d want to support it in Babel but not the core parser. I've come across that differentiation a few times when reading earlier e-mails. Is there any resource explaining the difference between these two parsers, what they are used for, and which sort of change should be done in which? Thanks

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

2022-01-04 Thread Gunnar Morling
attern() method without the Locale parameter, but this failed the forbiddenApis check as well :) Julian Best, --Gunnar > > > > On Jan 3, 2022, at 12:30 PM, Gunnar Morling > wrote: > > > > Hi, > > > > Thanks a lot for this, I think trimming down the depend

[jira] [Created] (CALCITE-4975) Remove dependency to commons-lang3

2022-01-04 Thread Gunnar Morling (Jira)
Gunnar Morling created CALCITE-4975: --- Summary: Remove dependency to commons-lang3 Key: CALCITE-4975 URL: https://issues.apache.org/jira/browse/CALCITE-4975 Project: Calcite Issue Type

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

2022-01-03 Thread Gunnar Morling
ly a lot of > > different components. For example, I have frequently wished that parser, > > planner and enumerable were separate modules. And if they were, I'd guess > > that each would have a narrower dependency range. I've also wished many > > times that runtime compilatio

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

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

2021-12-29 Thread Gunnar Morling
Hi, In a way, Calcite's build configuration as well as the published POM could be considered as such an SBOM? In particular when looking at the latter through services like mvnrepository [1], you get quite a good view on the dependency versions, licenses, any potential CVEs, etc. I think this

Re: How to obtain metadata for tables in sub-schemas?

2021-12-29 Thread Gunnar Morling
String[] {“TABLE”})); > Same result, no sub-schema tables are returned. I've logged https://issues.apache.org/jira/browse/CALCITE-4969 for this. Julian > Thanks, --Gunnar > > > > On Dec 28, 2021, at 1:45 PM, Gunnar Morling > wrote: > > > > Hi, > > > >

[jira] [Created] (CALCITE-4969) Can't retrieve metadata for tables in sub-schemas

2021-12-29 Thread Gunnar Morling (Jira)
Gunnar Morling created CALCITE-4969: --- Summary: Can't retrieve metadata for tables in sub-schemas Key: CALCITE-4969 URL: https://issues.apache.org/jira/browse/CALCITE-4969 Project: Calcite