[ https://issues.apache.org/jira/browse/HIVE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pengcheng Xiong reassigned HIVE-9897: ------------------------------------- Assignee: Pengcheng Xiong > Issue a warning when using an existing table/view name as an alias in a with > statement. > ---------------------------------------------------------------------------------------- > > Key: HIVE-9897 > URL: https://issues.apache.org/jira/browse/HIVE-9897 > Project: Hive > Issue Type: Improvement > Components: Hive > Affects Versions: 0.13.1 > Environment: cdh5.3.0 > Reporter: Mario Konschake > Assignee: Pengcheng Xiong > Priority: Minor > > Consider the following query: > {code:sql} > WITH > table_a AS ( > SELECT > 'johndoe' AS name > FROM > my_table > ) > SELECT > DISTINCT name > FROM > table_a; > {code} > Observation: > If a table or a view with name `table_a` exists it is used instead of the one > defined in the WITH statement. > Expectation: > As the expectation is ambiguous (using the alias in the WITH statement vs. > using the existing table) issuing a warning when using a existing name in a > WITH statement is recommended. -- This message was sent by Atlassian JIRA (v6.3.4#6332)