[jira] [Created] (CALCITE-4645) Search In Range is not supported in elastic search adapter

2021-06-09 Thread Jacky Yin (Jira)
Jacky Yin created CALCITE-4645: -- Summary: Search In Range is not supported in elastic search adapter Key: CALCITE-4645 URL: https://issues.apache.org/jira/browse/CALCITE-4645 Project: Calcite

Re: Optimizer (Hep) NOT scanning RelNodes of Subqqueries

2021-06-09 Thread Julian Hyde
I presume we’re talking about scalar sub-queries (e.g. sub-query in SELECT) and sub-queries with IN and EXISTS, as opposed to sub-queries in the FROM clause. The former are represented using RexSubQuery because the queries appear in scalar expressions. There are rules to expand RexSubQuery

Re: Optimizer (Hep) NOT scanning RelNodes of Subqqueries

2021-06-09 Thread Haisheng Yuan
Did you include the subquery related rules in the HepPlanner? Haisheng On 2021/06/09 17:59:44, Krishnakant Agrawal wrote: > Hi All, > > When running a HepOptimizer on top of a RelNode which has a subquery > embedded in it, The Optimizer does not take the RelNode representing the > subquery up

Optimizer (Hep) NOT scanning RelNodes of Subqqueries

2021-06-09 Thread Krishnakant Agrawal
Hi All, When running a HepOptimizer on top of a RelNode which has a subquery embedded in it, The Optimizer does not take the RelNode representing the subquery up for optimization. Is this by design, what's the correct way for the Subquery RelNode to be picked up for Optimization? If this is a

Re: [HELP] Calcite interpreting SQL to Druid DSL Question

2021-06-09 Thread Ben Krug
Hi Xu - I think it should work the way you expect. It would help to know the steps that you followed to set it up. When you say a tutorial, which one? Do you mean this - https://calcite.apache.org/docs/druid_adapter.html ? What steps did you take to set it up and run the query? Thank you, Ben

Re: Problem with Spool (de-)serialization

2021-06-09 Thread Konstantin Orlov
Yes, it’s possible. But my concern is the lack of common approach. Here a few examples: 1) Correlate and Join both explains joinType as lowerName of enum’s value, hence it could be simply restored by relInput.getEnum("joinType", JoinRelType.class) @Override public RelWriter