Mario Konschake created HIVE-9897:
-------------------------------------
Summary: 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:
WITH
table_a AS (
SELECT
'johndoe' AS name
FROM
my_table
)
SELECT
DISTINCT name
FROM
table_a;
Observation:
If 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 table name in
a WITH statement is recommended.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
