[
https://issues.apache.org/jira/browse/PHOENIX-565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-565.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by
first re-opening all closed imported issues and then resolving them in bulk.
> Issue with table aliases
> ------------------------
>
> Key: PHOENIX-565
> URL: https://issues.apache.org/jira/browse/PHOENIX-565
> Project: Phoenix
> Issue Type: Task
> Reporter: bennychow
>
> When the table name and alias names are the same, Phoenix is unable to parse
> columns qualified by the alias name:
> select sum("WEB_STAT"."ACTIVE_VISITOR") as "m0" from "WEB_STAT" "WEB_STAT"
> Error: ERROR 501 (42000): Table name exists in more than one table schema and
> is used without being qualified.
> SQLState: 42000
> ErrorCode: 0
--
This message was sent by Atlassian JIRA
(v6.2#6252)