[HIVE-20462] "CREATE VIEW IF NOT EXISTS" fails if view already exists

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 4.0.0-alpha-1

Environment

HDP 3.0

Hive 3.1.0.3.0.0.0-1634

• Target Version/s: 3.2.0, 4.0.0
• Hadoop Flags: Reviewed
• Assignee: Daniel Dai
• Reporter: static-max
• Created: 25/Aug/18 09:16
• Updated: 27/Feb/24 22:23
• Resolved: 15/Sep/18 23:00

Description

After upgrading to Hive 3.1 from Hive 1.2, I can't run my queries anymore. It seems that "if not exists" is ignored in "create view".

Example:

1. create view if not exists test as select 1;
2. create view if not exists test as select 1;

The second call fails with "Table already exists: default.test". I changed this to "create or replace view" as a workaround.

Also documented link here

Issue Links

• is related to: HIVE-21675 CREATE VIEW IF NOT EXISTS broken