[ https://issues.apache.org/jira/browse/HIVE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14544680#comment-14544680 ]
Pengcheng Xiong commented on HIVE-9897: --------------------------------------- I agree with [~hagleitn] and [~jpullokkaran] that this is a bug. We will address this together in HIVE-10698. > 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} > 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)