Dilip Kumar created HIVE-23115:
----------------------------------
Summary: SQL with "WITH" clause not suppoting Uppercase table name
while creating Views
Key: HIVE-23115
URL: https://issues.apache.org/jira/browse/HIVE-23115
Project: Hive
Issue Type: Bug
Components: Beeline
Affects Versions: 2.1.1
Reporter: Dilip Kumar
*Beeline version 2.1.1-mapr-1912*
SQL with "WITH" clause not suppoting Uppercase table name while creating Views
Below query creates the VIEW successfully,
CREATE VIEW default.TEST_VIEW as
with TEMP_TABLE as (select col1,col2 from table1)
SELECT col1 from TEMP_TABLE limit 1;
but when I execute select query on the view throws below error
{color:#FF0000}Error: Error while compiling statement: FAILED:
SemanticException Line 3:90 Table not found 'TEMP_TABLE' in definition of VIEW
TEST_VIEW{color}
When you replace uppercase TEMP_TABLE to lower case temp_table and query the
Vew-TEST_VIEW it works,
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
