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)

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

Reply via email to