Re: Unable to implement EnumerableAggregate(group=[{}], EXPR$0=[COUNT($0)]) with ReflectiveSchema

2022-02-11 Thread xiaobo
We come to the conclusion that fileds for tables and columns of the target class must be public, and those not for tables and columns must not be public, are we right? -- Original -- From: "xiaobo ";; Send time: Saturday, Feb 12, 2022 9:57 AM To: "dev";

Re: calcite multi-threading problem

2022-02-11 Thread xiaobo
In our use case, the Java class which opens calcite connection is contained in a external Java jar file, which is loaded dynamicly through classloaders other than the default systemloader like this: try { ClassLoader loader = URLClassLoader.newInstance( new

Re: calcite multi-threading problem

2022-02-11 Thread xiaobo
And if we remove calcite from our project, janino is not in "resolved depencies" library list of pom.xml, So we think it not the janino conflic problem. -- Original -- From: "xiaobo ";; Send time: Saturday, Feb 12, 2022 9:49 AM To: "dev"; Subject: Re:

Re: can we set a default schema for calcite connection to avoid writing schema names in sql

2022-02-11 Thread xiaobo
sorry for the html escape characters, we tried the following and it does not work Class.forName("org.apache.calcite.jdbc.Driver"); Properties info = new Properties(); info.setProperty("lex", "JAVA");

Unable to implement EnumerableAggregate(group=[{}], EXPR$0=[COUNT($0)]) with ReflectiveSchema

2022-02-11 Thread xiaobo
Simple count sql against ReflectiveSchema failed with : Error while executing SQL "select count(a.PA01AI01) from p.PRH_PA01 as a ": Unable to implement EnumerableAggregate(group=[{}], EXPR$0=[COUNT($0)]): rowcount = 10.0, cumulative cost = {111.25 rows, 101.0 cpu, 0.0 io}, id = 37

Re: 回复:cannot be cast to class org.apache.calcite.runtime.FlatLists$ComparableList error

2022-02-11 Thread xiaobo
Sorry for the HTML escape characters, I rewrite the problem as following: SQL select count(a.PA01AI01) from p.PRH_PA01 as a failed with : Caused by: java.sql.SQLException: Error while executing SQL "select count(a.PA01AI01) from p.PRH_PA01 as a ": From line 1, column 16 to line 1, column 23:

Re: calcite multi-threading problem

2022-02-11 Thread xiaobo
can you share the solution for the problem, we are using the following libraries, and it seems janino 3.1.6 is only dependent by calcite-core. UTF-8 UTF-8 9 9 9 2.17.1 7.64.0.Final org.apache.calcite

Re: calcite multi-threading problem

2022-02-11 Thread xiaobo
sorry about that, I'll correct it. -- Original -- From: "Julian Hyde";; Send time: Saturday, Feb 12, 2022 9:41 AM To: "dev"; Subject: Re: calcite multi-threading problem xiaobo, Your emails are coming through with a lot of HTML escape characters [1]. To

Re: calcite multi-threading problem

2022-02-11 Thread Julian Hyde
xiaobo, Your emails are coming through with a lot of HTML escape characters [1]. To make them more readable for everyone else, could you perhaps try sending in “Plain text” mode? Julian [1] https://lists.apache.org/thread/ttrlw4c441br27lppxl77osbgxrv58wn > On Feb 11, 2022, at 5:36 PM, xiaobo

Re: calcite multi-threading problem

2022-02-11 Thread xiaobo
can you share the solution for the problem, we are using the following libraries, and it seems janino 3.1.6 is only dependent by calcite-core.

Re: calcite multi-threading problem

2022-02-11 Thread xiong duan
Yes, It is a dependency issue. I have met the same problem. +1 for Dmitry. Dmitry Sysolyatin 于2022年2月11日周五 21:18写道: > Actually, I had the same problem with spark. Spark 3.2.1 uses the old > version of janino, calcite 1.29 uses the new version of janino and they are > not compatible. > If I

Re: Contributor role request

2022-02-11 Thread Francis Chuang
Hey Thomas, I've added you as a contributor in jira. Francis On 12/02/2022 9:00 am, Thomas D'Silva wrote: Hi. I would like to contribute to the calcite project, could you please grant me the contributor role? My Apache JIRA login is tdsilva. Thank you, Thomas D'Silva

Contributor role request

2022-02-11 Thread Thomas D'Silva
Hi. I would like to contribute to the calcite project, could you please grant me the contributor role? My Apache JIRA login is tdsilva. Thank you, Thomas D'Silva

[jira] [Created] (CALCITE-5010) Modify RexBuilder to use convertlets to transform the RexCall when possible

2022-02-11 Thread Thomas D'Silva (Jira)
Thomas D'Silva created CALCITE-5010: --- Summary: Modify RexBuilder to use convertlets to transform the RexCall when possible Key: CALCITE-5010 URL: https://issues.apache.org/jira/browse/CALCITE-5010

回复:cannot be cast to class org.apache.calcite.runtime.FlatLists$ComparableList error

2022-02-11 Thread xiaobo
the first filed's java class is as following, and SQL select count(a.PA01AI01) from p.PRH_PA01 as a failed with : Caused by: java.sql.SQLException: Error while executing SQL "select count(a.PA01AI01) from p.PRH_PA01 as a ": From line 1, column 16 to line 1, column 23: Column 'PA01AI01'

can we set a default schema for calcite connection to avoid writing schema names in sql

2022-02-11 Thread xiaobo
we have tried the following and it does not work Class.forName("org.apache.calcite.jdbc.Driver"); Properties info = new Properties(); info.setProperty("lex", "JAVA"); info.setProperty(CalciteConnectionProperty.CASE_SENSITIVE.camelName(), "false");

回复:reply: calcite multi-threading problem

2022-02-11 Thread xiaobo
I mean it seems not a janino related problem, if we put the connection opening and sql executing operationes in the same thread the same error does not appear, but with a sql related problem with I sent in another mail. --原始邮件-- 发件人:

reply: calcite multi-threading problem

2022-02-11 Thread xiaobo
we use maven and the effective pom contains only the 3.1.0 version of janino as following:

Re: calcite multi-threading problem

2022-02-11 Thread Dmitry Sysolyatin
Actually, I had the same problem with spark. Spark 3.2.1 uses the old version of janino, calcite 1.29 uses the new version of janino and they are not compatible. If I downgrade janino version to version which spark uses I got an error not method found exception If I upgrade the janino version to

Re: calcite multi-threading problem

2022-02-11 Thread stanilovsky evgeny
for example on a current calcite branch: grep janino gradle.properties janino.version=3.1.6 yes, we use drools in the same project, and drools uses janino too, is there a version list of janino which calcite supports? ---Original--- From: "Dmitry Sysolyatin"

Re: calcite multi-threading problem

2022-02-11 Thread xiaobo
yes, we use drools in the same project, and drools uses janino too, is there a version list of janino which calcite supports? ---Original--- From: "Dmitry Sysolyatin"

Re: calcite multi-threading problem

2022-02-11 Thread xiaobo
yes, we use drools in the same project, and drools uses janino too, is there a version list of janino which janino supports? ---Original--- From: "Dmitry Sysolyatin"

Request for review

2022-02-11 Thread Roman Puchkovskiy
Hi everyone! I published a PR https://github.com/apache/calcite/pull/2718 concerning the following Jira issue: https://issues.apache.org/jira/browse/CALCITE-5008 Could please someone review the PR? The CI seems to be ok with it. If I'm not doing the correct thing requesting a review here,

Re: calcite multi-threading problem

2022-02-11 Thread Dmitry Sysolyatin
Hi! It looks like a dependency issue, not like a multi-threading issue. Most likely you have some dependency that use another version of janino but calcite requires another one On Fri, Feb 11, 2022 at 12:18 PM xiaobo wrote: > Hi, > > > we open a calcite connection with ReflectiveSchema in one

calcite multi-threading problem

2022-02-11 Thread xiaobo
Hi, we open a calcite connection with ReflectiveSchema in one thread, and execute sqls in other threads against the connection, but failed with this error com.google.common.util.concurrent.ExecutionError: java.lang.NoSuchMethodError:

Re: [DISCUSS] Assigning reviewers

2022-02-11 Thread Zoltan Haindrich
Hey, I think the main problem is still the lack of active committers/reviewers and not so much the assignment. Totally agree - I think this is the core of the problem; the assign-by-files could somewhat help pulling in the right people - but will not make the job done. We could opt for

cannot be cast to class org.apache.calcite.runtime.FlatLists$ComparableList error

2022-02-11 Thread xiaobo
Hi, Our testing code failed with the following error, can you help with it: Error while executing SQL "select count(1) from p.PRH_PA01 ": class com.xsmartware.pbcm.sdk.pbc2p.PRH_PA01 cannot be cast to class org.apache.calcite.runtime.FlatLists$ComparableList

Re: Allow Cascades driver invoking "derive" on the nodes produced by "passThrough"

2022-02-11 Thread Alessandro Solimando
Hello everyone, @Vladimir, +1 on the change introducing "enforceDerive()". @Roman, could you walk us through the limitations you found that forced you to copy-paste the whole class? Maybe there is some middle ground for your problem(s) too, similar in spirit to what Vladimir proposed for the