[GitHub] [calcite] hsyuan commented on issue #1171: [CALCITE-3011] Support for joins with AggregateJoinTransposeRule

[GitBox <gi...@apache.org>]

hsyuan commented on issue #1171: [CALCITE-3011] Support for joins with AggregateJoinTransposeRule
URL: https://github.com/apache/calcite/pull/1171#issuecomment-485632898
 
 
   query and comment don't match.
   
   
   
   
   
   Thanks~
   Haisheng Yuan------------------------------------------------------------------
   发件人：Vineet G<no...@github.com>
   日　期：2019年04月23日 11:44:36
   收件人：apache/calcite<ca...@noreply.github.com>
   抄　送：Haisheng Yuan<h....@alibaba-inc.com>; Mention<me...@noreply.github.com>
   主　题：Re: [apache/calcite] [CALCITE-3011] Support for joins with AggregateJoinTransposeRule (#1171)
   
   @vineetgarg02 commented on this pull request. 
   In core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java:
   > +        + "full outer join sales.emp as d on e.job = d.job\n"
   +        + "group by e.ename,d.mgr";
   +    checkPlanning(tester, preProgram, new HepPlanner(program), sql);
   +  }
   +
   +  // full outer join, group by key is susbset of join keys
   +  @Test public void testPushAggregateThroughtOuterJoin16() {
   +    final HepProgram preProgram = new HepProgramBuilder()
   +        .addRuleInstance(AggregateProjectMergeRule.INSTANCE)
   +        .build();
   +    final HepProgram program = new HepProgramBuilder()
   +        .addRuleInstance(AggregateJoinTransposeRule.EXTENDED)
   +        .build();
   +    final String sql = "select e.job\n"
   +        + "from (select * from sales.emp where empno = 10) as e\n"
   +        + "left outer join sales.dept as d on e.job = d.name\n"
   
   @hsyuan Sorry I didn't understand what do you mean by left outer?
   —
   You are receiving this because you were mentioned.
   Reply to this email directly, view it on GitHub, or mute the thread.  
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services