Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
2.1.1
-
None
-
None
Description
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
Error: Error while compiling statement: FAILED: SemanticException Line 3:90 Table not found 'TEMP_TABLE' in definition of VIEW TEST_VIEW
When you replace uppercase TEMP_TABLE to lower case temp_table and query the Vew-TEST_VIEW it works,