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 "Zoltán Borók-Nagy (Jira)" <ji...@apache.org> on 2021/10/01 09:28:00 UTC

[jira] [Updated] (IMPALA-10946) RECOVER PARTITIONS might create non-existing partitions

     [ https://issues.apache.org/jira/browse/IMPALA-10946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltán Borók-Nagy updated IMPALA-10946:
---------------------------------------
    Description: 
The following commands reproduce the bug:
{noformat}
create table test_table (id int)
partitioned by (part_field string)
stored as parquet
LOCATION ‘/test-warehouse/abc/test’;

insert into test_table (id, part_field) select 1, ‘abc+’;

show partitions test_table; ----> it will show one partition “abc+”

alter table test_table recover partitions;

show partitions test_table; ----> result is showing two partitions, “abc” and “abc+”
{noformat}

The + character can occur anywhere in the string, RECOVER PARTITIONS will create a partition where the + is replaced by a space.

Seems like other characters don't cause this bug.

  was:
The following commands reproduce the bug:
{noformat}
create table test_table (id int)
partitioned by (part_field string)
stored as parquet
LOCATION ‘/test-warehouse/abc/test’;

insert into test_table (id, part_field) select 1, ‘abc+’;

show partitions test_table; ----> it will show one partition “abc+”

alter table test_table recover partitions;

show partitions test_table; ----> result is showing two partitions, “abc” and “abc+”
{noformat}

The '+' character can occur anywhere in the string, RECOVER PARTITIONS will create a partition where the '+' is replaced by a space.

Seems like other characters don't cause this bug.


> RECOVER PARTITIONS might create non-existing partitions
> -------------------------------------------------------
>
>                 Key: IMPALA-10946
>                 URL: https://issues.apache.org/jira/browse/IMPALA-10946
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Catalog, Frontend
>            Reporter: Zoltán Borók-Nagy
>            Priority: Major
>
> The following commands reproduce the bug:
> {noformat}
> create table test_table (id int)
> partitioned by (part_field string)
> stored as parquet
> LOCATION ‘/test-warehouse/abc/test’;
> insert into test_table (id, part_field) select 1, ‘abc+’;
> show partitions test_table; ----> it will show one partition “abc+”
> alter table test_table recover partitions;
> show partitions test_table; ----> result is showing two partitions, “abc” and “abc+”
> {noformat}
> The + character can occur anywhere in the string, RECOVER PARTITIONS will create a partition where the + is replaced by a space.
> Seems like other characters don't cause this bug.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org