[jira] [Comment Edited] (PHOENIX-3712) Column alias can't be resolved in GROUP BY clause

["Kevin Liew (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15895889#comment-15895889 ] 

Kevin Liew edited comment on PHOENIX-3712 at 3/4/17 9:40 PM:
-------------------------------------------------------------

Changing the test case is fine but we should track this and eventually re-enable aliases in group-by as some BI tools rely on this.
PHOENIX-2930


was (Author: kliew):
Changing the test case is fine but we should track this and re-enable aliases in group-by as some BI tools rely on this.
PHOENIX-2930

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