Re: calcite multi-threading problem

Hi, I haven't gone through all the exchanges but wanted to mention that in general the JDBC connection APIs are not thread-safe. You previously mentioned the following: "we open a calcite connection with ReflectiveSchema in one thread, and execute sqls in other threads against the connection, bu

Re:Connect Calcite to Sqlite

Hi, Pan. It will be much better to go through your issue if you show us how you use Calcite to connect Sqlite and what the StackTrace is. There is one demo in core/src/test/resources/mysql-foodmart-model.json you can take a look. By adding a new file(like sqlite.json) which stores connection p

"Unable to implement EnumerableNestedLoopJoin in SELECT(a, b, ARRAY(c, d, ARRAY(e)))"

The following query seems to work perfectly: SELECT "houses"."id", "houses"."name", "houses"."address", ARRAY( SELECT "users"."id", "users"."name" FROM "users" WHERE "users"."house_id" = "houses"."id" ) AS

[DISCUSS] Towards Calcite 1.30.0

Hello, It has been almost two months since our last release [1], and I think we should make an effort to continue keeping the rhythm of one release every two months approximately. If I am not mistaken, the next release managers would be [2]: - Andrei Sereda for 1.30.0 - Liya Fan for 1.31.0 Are y

Re: [DISCUSS] Assigning reviewers

Hello, I agree that this is a long-lasting issue in our project. Normally, when I see a lack of reaction in one of my PRs, I check the impacted file(s) history and try to contact directly someone that has worked on it in the past in order to help with the review. But I admit this is an imperfect a

Re: "Unable to implement EnumerableNestedLoopJoin in SELECT(a, b, ARRAY(c, d, ARRAY(e)))"

Hello Gavin, what's the full stack trace that you get? On Mon, Feb 14, 2022 at 3:24 PM Gavin Ray wrote: > The following query seems to work perfectly: > > SELECT > "houses"."id", > "houses"."name", > "houses"."address", > ARRAY( > SELECT > "users"."id", >

Database Engineering Opportunity at Workday

Howdy! We have an opening on our team, and people in the Calcite development organization would be a really good fit! Job Posting: https://workday.wd5.myworkdayjobs.com/Workday/job/USA-CA-Pleasanton/Sr-Software-Engineer--Query-_JR-61589 This specific position is for the Pleasanton California Wor

Re: "Unable to implement EnumerableNestedLoopJoin in SELECT(a, b, ARRAY(c, d, ARRAY(e)))"

Apologies for the slow reply Ruben, I appreciate your help. The full stack trace (I was prototyping in sqlline) seems to be more helpful: Here is what seems to be the most useful bits: == java.sql.SQLException: Error while preparing plan [EnumerableCorrelate(cor

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

See

Some questions about lattices

hello, I'm reading code about star materialized views ,These problems keeps making me puzzled. can you tell me some information about the lattice and star-materialization-view ？ from the code ，I find two place about star-materialization-view： 1. before use materialization by UnifyRule p

Re: Failed to import gradle

Hi Julian&Gravin Sorry for the late response, I tried the solution posted by Gravin, The IDE can work with calcite project now. The changed files are modified: .idea/vcs.xml modified: build.gradle.kts modified: buildSrc/build.gradle.kts modified: core/b