[HIVE-20010] Fix create view over literals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1.2, 3.2.0, 4.0.0-alpha-1
• Target Version/s: 3.1.0, 4.0.0
• Hadoop Flags: Reviewed
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 27/Jun/18 11:50
• Updated: 21/Oct/22 06:59
• Resolved: 28/Jun/18 20:17

Description

create or replace view v1 as select 1 as q 

results in an error:

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Table already exists: default.v1 (state=08S01,code=1)

however the following works (thank you mgergely)

create or replace view v1 as select 1 as q union all select 1 as qq where false

Issue Links

• blocks: HIVE-19938 Upgrade scripts for information schema
• is duplicated by: HIVE-20872 Creating information_schema and sys schema via schematool fails with parser error
• is duplicated by: HIVE-19444 Create View - Table not found _dummy_table