[
https://issues.apache.org/jira/browse/PHOENIX-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15901772#comment-15901772
]
Kevin Liew commented on PHOENIX-3712:
-------------------------------------
I will pick up that JIRA, though I might split it into two subtasks, as
grouping by ordinal is only used once in the Phoenix test suite.
> Column alias can't be resolved in GROUP BY clause
> -------------------------------------------------
>
> Key: PHOENIX-3712
> URL: https://issues.apache.org/jira/browse/PHOENIX-3712
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Labels: calcite
>
> There are quite a few test cases written like:
> {{select v1 - 1 as v, sum(v2) from t group by v}} in Phoenix test suite, and
> calcite does not allow using aliases defined in SELECT list to be referred by
> GROUP BY clause (ok for ORDER BY though), shall we change those test cases?
> FYI, [~julianhyde], [~jamestaylor], [~rajeshbabu], [~kliew]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
