Khaliullin Aidar created IMPALA-14779:
-----------------------------------------
Summary: UB on minmax filter with timestamp partioned tables
Key: IMPALA-14779
URL: https://issues.apache.org/jira/browse/IMPALA-14779
Project: IMPALA
Issue Type: Bug
Components: Backend
Affects Versions: Impala 4.5.0
Reporter: Khaliullin Aidar
In case you create a table partitioned by timestamp
{code:java}
CREATE EXTERNAL TABLE dm_abo.gen_benefitfl_tct (party_src_code STRING NOT
NULL,party_crm_code STRING NOT NULL,party_abo_code STRING NOT
NULL,operation_code STRING NOT NULL,operation_src_code STRING NOT
NULL,deal_src_code STRING NOT NULL,cardno_code STRING NOT NULL,operation_nm_amt
DECIMAL(19,4) NOT NULL,fact_dttm TIMESTAMP NOT NULL,benefit_type_name STRING
NOT NULL,oper_type_name STRING NOT NULL,product_name STRING NOT
NULL,deleted_flag BOOLEAN NOT NULL,source_code STRING
NULL,functionrun_insert_id BIGINT NULL,functionrun_update_id BIGINT
NULL,sys_insert_stamp TIMESTAMP NULL,sys_update_stamp TIMESTAMP
NULL)PARTITIONED BY SPEC(MONTH(fact_dttm))STORED AS ICEBERG {code}
for timestamp based on int64 has ub state. This leads to incorrect results in
join queries.
https://github.com/apache/impala/blob/master/be/src/exec/parquet/parquet-column-stats.cc#L230
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
