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

Posted to dev@phoenix.apache.org by "Maryann Xue (JIRA)" <ji...@apache.org> on 2017/03/04 00:18:45 UTC

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

Maryann Xue created PHOENIX-3712:
------------------------------------

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


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)