[IMPALA-11758] Databases named "iceberg" confuses the parser, throws ParseException

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.3.0
• Labels: docs-impacting
• Epic Color: ghx-label-9
• Assignee: Gergely Fürnstáhl
• Reporter: Gergely Fürnstáhl
• Created: 29/Nov/22 16:44
• Updated: 19/Sep/23 16:48
• Resolved: 28/May/23 11:50

Description

Impala can't create a database named "iceberg" but hive can. Valid queries fails in impala using that database.

[localhost:21050] default> create database iceberg;
Query: create database iceberg
ERROR: ParseException: Syntax error in line 1:
create database iceberg
                ^
Encountered: ICEBERG
Expected: DEFAULT, EXTENDED, FORMATTED, IF, IDENTIFIER 

Created database in hive.

[localhost:21050] default> use iceberg;
Query: use iceberg
ERROR: ParseException: Syntax error in line 1: use iceberg   
  ^
Encountered: ICEBERG
Expected: DEFAULT, IDENTIFIER CAUSED BY: Exception: Syntax error
 

Selects fails too on existing tables.

Escaping solves the issue, e.g.:

CREATE TABLE `iceberg`.`ice_9c` (i INT, t TIMESTAMP) PARTITIONED BY (j BIGINT) STORED AS ICEBERG TBLPROPERTIES ('format-version' = '2');

Improving exception message could help the users in the future