[
https://issues.apache.org/jira/browse/IMPALA-11758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gergely Fürnstáhl updated IMPALA-11758:
---------------------------------------
Description:
Impala can't create a database named "iceberg" but hive can. Valid queries
fails in impala using that database.
{code:java}
[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 {code}
Created database in hive.
{code:java}
[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
{code}
Selects fails too on existing tables.
Escaping solves the issue, e.g.:
{code:java}
CREATE TABLE `iceberg`.`ice_9c` (i INT, t TIMESTAMP) PARTITIONED BY (j BIGINT)
STORED AS ICEBERG TBLPROPERTIES ('format-version' = '2');{code}
Improving exception message could help the users in the future
was:
Impala can't create a database named "iceberg" but hive can. Valid queries
fails in impala using that database.
{code:java}
[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 {code}
Created database in hive.
{code:java}
[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
{code}
Selects fails too on existing tables.
Escaping solves the issue, e.g.:
{code:java}
CREATE TABLE `iceberg`.`ice_9c` (i INT, t TIMESTAMP) PARTITIONED BY (j BIGINT)
STORED AS ICEBERG TBLPROPERTIES ('format-version' = '2');{code}
Issue Type: Improvement (was: Bug)
> Databases named "iceberg" confuses the parser, throws ParseException
> --------------------------------------------------------------------
>
> Key: IMPALA-11758
> URL: https://issues.apache.org/jira/browse/IMPALA-11758
> Project: IMPALA
> Issue Type: Improvement
> Reporter: Gergely Fürnstáhl
> Assignee: Gergely Fürnstáhl
> Priority: Major
>
> Impala can't create a database named "iceberg" but hive can. Valid queries
> fails in impala using that database.
> {code:java}
> [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 {code}
> Created database in hive.
> {code:java}
> [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
> {code}
> Selects fails too on existing tables.
> Escaping solves the issue, e.g.:
> {code:java}
> CREATE TABLE `iceberg`.`ice_9c` (i INT, t TIMESTAMP) PARTITIONED BY (j
> BIGINT) STORED AS ICEBERG TBLPROPERTIES ('format-version' = '2');{code}
> Improving exception message could help the users in the future
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
