that is
> > > > not a simple mapping, and do the same task I mentioned above.
> > > >
> > > > - Haisheng
> > > >
> > > > --
> > > > 发件人：Rommel Quintanilla
> >
r hand, instead of creating a new intermidiate pogical
> > project,
> > > we can also update ProjectTableScanRule to accept LogicalProject that is
> > > not a simple mapping, and do the same task I mentioned above.
> > >
> > > - Haisheng
> > >
>
> Haisheng Yuan 于2019年10月12日周六 上午4:34写道：
> > > >
> > > > > Yes, definitely.
> > > > >
> > > > > You can go through the project expression with InputFinder to find
> all
> > > > the
> > > > > used columns, create
>
> > > > On the other hand, instead of creating a new intermidiate pogical
> > > project,
> > > > we can also update ProjectTableScanRule to accept LogicalProject that
> > is
> > > > not a simple mapping, and do the same task I mentioned above.
> > > >
>
I mean, testPushNonSimpleMappingProject [1] runs with RelFieldTrimmer
enabled, which is done by [2]
[1]
https://github.com/apache/calcite/pull/1500/files#diff-3c834a32d46b821b5241e132f2ae6bfaR324
[2]
Yes, that's how testPushNonSimpleMappingProject [1] works
[1]
https://github.com/apache/calcite/pull/1500/files#diff-3c834a32d46b821b5241e132f2ae6bfaR324
Danny Chan 于2019年10月14日周一 下午3:36写道：
> > But why the final BindableTableScan is not pruned ?
>
> The RelFieldTrimmer default is turned off,
> But why the final BindableTableScan is not pruned ?
The RelFieldTrimmer default is turned off, you should open it explicitly.
Best,
Danny Chan
在 2019年10月14日 +0800 AM11:51，dev@calcite.apache.org，写道：
>
> BINDABLE_TABLE_SCAN_RULE
Also regarding that Projects merging is common in Calcite optimization
rules, we should always remember to avoid merging for cases like the one
given by Rommel.
I think that would be hard.
Best,
Jin
XING JIN 于2019年10月14日周一 上午11:51写道：
> Hi, Stamatis, Danny~
>
> Thanks for explain ~
>
> > "The
Hi, Stamatis, Danny~
Thanks for explain ~
> "The consumer in the case of P1 is the project which only needs $0, $2,
$5,
$6 so the trimmer could slim down the scan by projecting only these fields."
I think RelFieldTrimmer is already doing this by [1].
But why the final BindableTableScan is not
+1, RelFieldTrimmer is the role to trim the unused fields.
Best,
Danny Chan
在 2019年10月13日 +0800 AM6:25，dev@calcite.apache.org，写道：
>
> RelFieldTrimmer
rote:
> >> >>
> >> >> > Filed a JIRA:
> >> >> > https://issues.apache.org/jira/browse/CALCITE-3405
> >> >> >
> >> >> > Haisheng Yuan 于2019年10月12日周六 上午4:34写道：
> >> >> >
> >> &
> Filed a JIRA:
> >> >> > https://issues.apache.org/jira/browse/CALCITE-3405
> >> >> >
> >> >> > Haisheng Yuan 于2019年10月12日周六 上午4:34写道：
> >> >> >
> >> >> > > Yes, definitely.
> >> >> > >
> >> >> > > You can go through the pr
ough the project expression with InputFinder to find
>> all
>> >> > the
>> >> > > used columns, create a logical project with those columns, and
>> remap
>> >> the
>> >> > > top project with new column indexes.
>> >&
op project with new column indexes.
> >> > >
> >> > > On the other hand, instead of creating a new intermidiate pogical
> >> > project,
> >> > > we can also update ProjectTableScanRule to accept LogicalProject
> that
> >>
es.
>> > >
>> > > On the other hand, instead of creating a new intermidiate pogical
>> > project,
>> > > we can also update ProjectTableScanRule to accept LogicalProject that
>> is
>> > > not a simple mapping, and do the same task
ting a new intermidiate pogical
> > project,
> > > we can also update ProjectTableScanRule to accept LogicalProject that
> is
> > > not a simple mapping, and do the same task I mentioned above.
> > >
> > > - Haisheng
> > >
> > > --
simple mapping, and do the same task I mentioned above.
> >
> > - Haisheng
> >
> > --------------
> > 发件人：Rommel Quintanilla
> > 日 期：2019年10月12日 03:15:31
> > 收件人：
> > 主 题：[QUESTION] Pushin
ioned above.
>
> - Haisheng
>
> --
> 发件人：Rommel Quintanilla
> 日 期：2019年10月12日 03:15:31
> 收件人：
> 主 题：[QUESTION] Pushing up evaluations from LogicalProjects
>
> Hi, maybe you can help me.
> I have this portion from a larger logical plan:
> ..
&g
update ProjectTableScanRule to accept LogicalProject that is not a
simple mapping, and do the same task I mentioned above.
- Haisheng
--
发件人：Rommel Quintanilla
日 期：2019年10月12日 03:15:31
收件人：
主 题：[QUESTION] Pushing up evaluations from
Hi, maybe you can help me.
I have this portion from a larger logical plan:
..
LogicalProject(l_orderkey=[$0], l_suppkey=[$2], *=[*($5, -(1, $6))])
LogicalTableScan(table=[[main, lineitem]])
..
Because the LogicalProject above contains an evaluation, the
20 matches
Mail list logo
