[HIVE-28307] Fast return when database exists and IF NOT EXISTS clause is enabled

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0, 4.0.1
• Component/s: Hive
• Labels: hive-4.0.1-merged pull-request-available
• Assignee: Wechar
• Reporter: Wechar
• Created: 06/Jun/24 08:09
• Updated: 25/Sep/24 04:44
• Resolved: 20/Jun/24 15:23

Description

When use beeline for testing purpose:

beeline -u jdbc:hive2://

CREATE TABLE IF NOT EXISTS will not print AlreadyExistsException, but CREATE DATABASE IF NOT EXISTS will.
The error log may be confused because the sql actually execute successfully.
 
The root cause is that SemanticAnalyzer will fast-return if table exists:
https://github.com/apache/hive/blob/98d9d22398370f817fe64449368671b978fff096/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java#L14163-L14174

Issue Links

• links to: GitHub Pull Request #5292