[ https://issues.apache.org/jira/browse/HIVE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mario Konschake updated HIVE-9897: ---------------------------------- Description: Consider the following query: {code:sql} WITH table_a AS ( SELECT 'johndoe' AS name FROM my_table ) SELECT DISTINCT name FROM table_a; {code:sql} 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. was: Consider the following query: WITH table_a AS ( SELECT 'johndoe' AS name FROM my_table ) SELECT DISTINCT name FROM table_a; 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. > 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 > 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:sql} > 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)