You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@calcite.apache.org by GitBox <gi...@apache.org> on 2019/12/17 07:09:23 UTC

[GitHub] [calcite] cshuo opened a new pull request #1669: [CALCITE-3590] Support SQL hints for Aggregate

cshuo opened a new pull request #1669: [CALCITE-3590] Support SQL hints for Aggregate
URL: https://github.com/apache/calcite/pull/1669
 
 
   Currently in [CALCITE-482](https://issues.apache.org/jira/browse/CALCITE-482), hints are only supported for Project, Join and TableScan. It's also necessary to support hints for Aggregate so as to enable fine grained Aggregate configuration, e.g., two-stage-aggregation.
   ```
   SELECT /*+ AGG_STRATEGY(TWO_PHASE) */ 
   dep_id,
   grade, 
   avg(annual_salary),
   min(annual_salary),
   max(annual_salary)
   FROM T
   GROUP BY dep_id, grade;
   ```

----------------------------------------------------------------
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