Re: Question about Interpreter and Corelations

> >> > As I said, I think you should log a bug. >> > >> > On Fri, Nov 8, 2019 at 10:23 AM Haisheng Yuan >> wrote: >> >> >> >> I am afraid this query can't be easily decorrelated. >> >> >> >> - Haisheng >&

Re: Question about Interpreter and Corelations

gt;> I am afraid this query can't be easily decorrelated. > >> > >> - Haisheng > >> > >> ---------- > >> 发件人：Zoltan Farkas > >> 日 期：2019年11月08日 22:46:53 > >> 收件人： > >> 主 题：Re: Question about Inter

Re: Question about Interpreter and Corelations

Nov 8, 2019 at 10:23 AM Haisheng Yuan wrote: >> >> I am afraid this query can't be easily decorrelated. >> >> - Haisheng >> >> -- >> 发件人：Zoltan Farkas >> 日　期：2019年11月08日 22:46:53 >&g

Re: Re: Question about Interpreter and Corelations

8日 22:46:53 > 收件人： > 主　题：Re: Question about Interpreter and Corelations > > Thanks Julian, > > Any idea how could I de-corelate the query? > RelDecorrelator.decorrelateQuery does not seem to alter the plan. > > Will log a jira for the interpreter issue. > > thank you

Re: Re: Question about Interpreter and Corelations

I am afraid this query can't be easily decorrelated. - Haisheng -- 发件人：Zoltan Farkas 日　期：2019年11月08日 22:46:53 收件人： 主　题：Re: Question about Interpreter and Corelations Thanks Julian, Any idea how could I de-corelate the query

Re: Question about Interpreter and Corelations

Thanks Julian, Any idea how could I de-corelate the query? RelDecorrelator.decorrelateQuery does not seem to alter the plan. Will log a jira for the interpreter issue. thank you —Z > On Nov 7, 2019, at 5:08 PM, Julian Hyde wrote: > > I don’t recall what the interpreter is currently

Re: Question about Interpreter and Corelations

Hi Zoltan, +1 on what Julian said. Interpreter is not 100% accurate in this case since as you probably realized this part of the code generates and compiles code. Other than that I confirm that the Interpreter is not able to handle correlations at the moment. Best, Stamatis On Thu, Nov 7, 2019

Re: Question about Interpreter and Corelations

I don’t recall what the interpreter is currently capable of, but you should log a bug. I wonder whether if you could get the query to work in the interpreter if you decorrelated the query first. Julian > On Nov 7, 2019, at 11:16, Zoltan Farkas wrote: > > for a test query with the

Question about Interpreter and Corelations

for a test query with the following plan: LogicalProject(name=[$1], friends=[$4]) LogicalCorrelate(correlation=[$cor0], joinType=[inner], requiredColumns=[{0}]) LogicalTableScan(table=[[characters]]) Collect(field=[EXPR$0]) LogicalProject(name=[$2])