[
https://issues.apache.org/jira/browse/PHOENIX-3749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15954731#comment-15954731
]
Ankit Singhal commented on PHOENIX-3749:
----------------------------------------
Duplicate of PHOENIX-2930
> 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
>
> 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)
