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