Re: [Bug Report]RelToSqlConverter stack error in 1.24-1.26

2020-12-07 Thread Chunwei Lei
Hi, Tao. Thank you for your report. It would be great if you can file an JIRA and provide a test case that can reproduce the error. Best, Chunwei On Tue, Dec 8, 2020 at 2:33 PM tonytao wrote: > Hi folks, > > I found a RelToSqlConverter bug existed in 1.24-1.26. > > I has a logical plan as bel

[Bug Report]RelToSqlConverter stack error in 1.24-1.26

2020-12-07 Thread tonytao
Hi folks, I found a RelToSqlConverter bug existed in 1.24-1.26. I has a logical plan as below:   LogicalProject(id=[$0], CAST=[CAST($1):DATE])     LogicalFilter(condition=[AND(<($1, 2011-12-01 00:00:00), >($0, 100))])   JdbcTableScan(table=[[public, testdata]]) when concert i

[jira] [Created] (CALCITE-4429) createCastRel should throw an exception when the field count of the row type to to be converted and desired row type is not equal

2020-12-07 Thread Chunwei Lei (Jira)
Chunwei Lei created CALCITE-4429: Summary: createCastRel should throw an exception when the field count of the row type to to be converted and desired row type is not equal Key: CALCITE-4429 URL: https://issues.

[DISCUSS] ISO-compliant behavior of SUBSTRING function

2020-12-07 Thread Julian Hyde
We've noticed that the SUBSTRING function complies with BigQuery "standard SQL" semantics but not ISO standard SQL semantics. I am proposing to fix it, and that necessitates some breaking changes that I have outlined in https://issues.apache.org/jira/browse/CALCITE-4427. If you care about this, pl

Re: Convert sqlnode to relRoot cost 14s

2020-12-07 Thread Julian Hyde
I am always skeptical of caches. They make some things better, and some things worse, and they make the whole system more complicated. There are other cases where we were converting expressions to left-deep or right-deep trees, which resulted in a cartesian (O(N^2)) algorithm, and we were able to

Re: How to convert a logical operator into multiple physical operators

2020-12-07 Thread Bhavya Aggarwal
Thanks for the reply, so I looked at the example and created a Nested RelNode for my TableScanOperator as shown below override def onMatch(call: RelOptRuleCall): Unit = { val tableScan : LogicalTableScan = call.rel[LogicalTableScan](0); val builder = call.builder() val newOp = new Read

Re: [HELP] Local build fails

2020-12-07 Thread Fan Liya
Thanks for the advice. I have tried jdk1.8.0_271 and jdk1.9 (build 9+181), but the problem is still there. Best, Liya Fan On Mon, Dec 7, 2020 at 1:51 PM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > Fan Liya, please update Java. It is the solution. > > Vladimir >