You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Gabor Kaszab (Jira)" <ji...@apache.org> on 2023/02/28 10:32:00 UTC

[jira] [Created] (IMPALA-11954) Partition an Iceberg table on a string col with '/' char gives incorrect results

Gabor Kaszab created IMPALA-11954:
-------------------------------------

             Summary: Partition an Iceberg table on a string col with '/' char gives incorrect results
                 Key: IMPALA-11954
                 URL: https://issues.apache.org/jira/browse/IMPALA-11954
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 4.0.0
            Reporter: Gabor Kaszab


Repro:
{code:java}
CREATE TABLE IF NOT EXISTS tmp_ice
(id int, date_string_col string)
PARTITIONED BY SPEC (date_string_col)
STORED AS ICEBERG;

insert into tmp_ice select id, date_string_col from functional_parquet.alltypes;

select * from tmp_ice where date_string_col = "09/01/09";
{code}
This select gives zero rows.

However, I create the table partitioned by another col, e.g. 'id' then the very same select gives 10 rows as expected.

The issue may be somewhere here where we split the path by '/' char:
https://github.com/apache/impala/blob/47c71bbb32d34d4583856af227206934b6f15136/fe/src/main/java/org/apache/impala/util/IcebergUtil.java#L693




--
This message was sent by Atlassian Jira
(v8.20.10#820010)