You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Gergely Fürnstáhl (Jira)" <ji...@apache.org> on 2022/11/29 16:48:00 UTC
[jira] [Updated] (IMPALA-11758) Databases named "iceberg" confuses the parser, throws ParseException
[ 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}
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.
> Databases named "iceberg" confuses the parser, throws ParseException
> --------------------------------------------------------------------
>
> Key: IMPALA-11758
> URL: https://issues.apache.org/jira/browse/IMPALA-11758
> Project: IMPALA
> Issue Type: Bug
> 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}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org