chen weihua created PHOENIX-3749:
------------------------------------
Summary: 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)
