Direction on CALCITE-5213, nested correlated subquery conversion

2024-08-20 Thread Ian Bertolacci
Hello, JIRA CALCITE-5213 has been open for a while now and still seems to be an issue. I’ve included small example which demonstrates the issue. I’m hoping someone can figure out what might be happening here (hopefully I’m just doing something wrong) and see if there are possible solutions. Thank

[jira] [Created] (CALCITE-6539) Improve error messages due to misspellings

2024-08-20 Thread Adam Markowitz (Jira)
Adam Markowitz created CALCITE-6539: --- Summary: Improve error messages due to misspellings Key: CALCITE-6539 URL: https://issues.apache.org/jira/browse/CALCITE-6539 Project: Calcite Issue Ty

[jira] [Created] (CALCITE-6540) RelOptUtil.pushDownJoinConditions does not correctly adjust ASOF joins match conditions

2024-08-20 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6540: Summary: RelOptUtil.pushDownJoinConditions does not correctly adjust ASOF joins match conditions Key: CALCITE-6540 URL: https://issues.apache.org/jira/browse/CALCITE-6540

[jira] [Created] (CALCITE-6541) Type inference for MOD operator is incorrect

2024-08-20 Thread Mihai Budiu (Jira)
Mihai Budiu created CALCITE-6541: Summary: Type inference for MOD operator is incorrect Key: CALCITE-6541 URL: https://issues.apache.org/jira/browse/CALCITE-6541 Project: Calcite Issue Type:

Where to go from tutorial to use the JDBC Adapter?

2024-08-20 Thread David Ventimiglia
Hello! The Calcite tutorial shows how to use a custom sqlline to connect to the Calcite JDBC driver with a model.json to use a simple adapter that makes a directory of CSV files appear to be a schema containing tables. Later, the tutorial shows what

Re: Sortlimit and limit examples

2024-08-20 Thread Eric Berryman
Is there something I’m missing about EnumerableLimit? It seems like I get an infinite cost anytime it’s in my path? Thank you again, Eric On Mon, Aug 19, 2024 at 18:00 Eric Berryman wrote: > I see the red circles in the svg query plan I added to the gist. I’m just > not sure what it’s supposed