You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Ankit Singhal (JIRA)" <ji...@apache.org> on 2017/04/04 07:44:41 UTC
[jira] [Commented] (PHOENIX-3749) ERROR 502 (42702): Column
reference ambiguous when order by duplicate names
[ 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)