[
https://issues.apache.org/jira/browse/CALCITE-3636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17003770#comment-17003770
]
Rui Wang edited comment on CALCITE-3636 at 12/26/19 9:37 PM:
-------------------------------------------------------------
I converted this Jira to a subtask of CALCITE-482.
Per the PR I think you want to propagate resource hint to sort and there is the
syntax in the PR:
select /*+ resource(mem='1024MB')*/ ename, sal, deptno from emp order by
deptno";
Until this moment, as we are adding more and more hintable RelNode, I start to
think how to distinguish the following cases:
1. resources only applied to Project
2. resources only applied to Sort
3. resources applied to both Sort and Project.
My question is, will the following syntax better?
select ename, sal, deptno from emp order by /*+ resource(mem='1024MB')*/
deptno" ?
cc: @danny0405
was (Author: amaliujia):
I converted this Jira to a subtask of CALCITE-482.
Per the PR I think you want to propagate resource hint to sort and there is the
syntax in the PR:
select /*+ resource(mem='1024MB')*/ ename, sal, deptno from emp order by
deptno";
My question is, will the following syntax better?
select ename, sal, deptno from emp order by /*+ resource(mem='1024MB')*/
deptno" ?
cc: @danny0405
> Implement RelHint for Sort
> ---------------------------
>
> Key: CALCITE-3636
> URL: https://issues.apache.org/jira/browse/CALCITE-3636
> Project: Calcite
> Issue Type: Sub-task
> Reporter: xzh_dz
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
