[jira] [Resolved] (PHOENIX-3749) ERROR 502 (42702): Column reference ambiguous when order by duplicate names

["Ankit Singhal (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-3749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ankit Singhal resolved PHOENIX-3749.
------------------------------------
       Resolution: Duplicate
    Fix Version/s: 4.9.0

> ERROR 502 (42702): Column reference ambiguous when order by duplicate names
> ---------------------------------------------------------------------------
>
>                 Key: PHOENIX-3749
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3749
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.8.0
>         Environment: CentOS6 JDK1.7.0_79
> x86_64 
>            Reporter: chen weihua
>             Fix For: 4.9.0
>
>
> Tableau generates queries that alias a fully-qualified column name to its shortened name.
> Similar to:
> select room_id, sum(error_code403) as error_code403
> from dla_node_main
> group by room_id 
> order by error_code403
> Phoenix reports:
> Error: ERROR 502 (42702): Column reference ambiguous or duplicate names. columnName=ERROR_CODE403
> SQLState:  42702
> ErrorCode: 502



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)