phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Liew (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-3712) Column alias can't be resolved in GROUP BY clause
Date Sat, 04 Mar 2017 21:40:45 GMT

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

Mime
View raw message