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: [email protected]
For additional commands, e-mail: [email protected]
