[jira] [Created] (HIVE-26552) PartitionConditionRemover doesn't remove constant filter with structs inside

["Hankó Gergely (Jira)" <ji...@apache.org>]

Hankó Gergely created HIVE-26552:
------------------------------------

             Summary: PartitionConditionRemover doesn't remove constant filter with structs inside
                 Key: HIVE-26552
                 URL: https://issues.apache.org/jira/browse/HIVE-26552
             Project: Hive
          Issue Type: Improvement
            Reporter: Hankó Gergely


Repro:
{code:java}
set hive.fetch.task.conversion=none;

create table test (a string) partitioned by (y string, m string);
insert into test values ('aa', 2022, 9);

explain vectorization expression select * from test where (y=year(date_sub('2022-09-11',4)) and m=month(date_sub('2022-09-11',4))) or (y=year(date_sub('2022-09-11',10)) and m=month(date_sub('2022-09-11',10)) ); {code}
Actual:
{code:java}
Filter Operator
  Filter Vectorization:
      className: VectorFilterOperator
      native: true
      predicateExpression: SelectColumnIsTrue(col 5:boolean)(children: VectorUDFAdaptor((const struct(2022.0D,9.0D)) IN (const struct(2022.0D,9.0D), const struct(2022.0D,9.0D))) -> 5:boolean)
  predicate: (const struct(2022.0D,9.0D)) IN (const struct(2022.0D,9.0D), const struct(2022.0D,9.0D)) (type: boolean)
  Statistics: Num rows: 1 Data size: 454 Basic stats: COMPLETE Column stats: COMPLETE {code}
Expected:

The filter operator should be optimized out similarly as it is removed in the following query:
{code:java}
explain vectorization expression select * from test where (y=year(date_sub('2022-09-11',4))) or (y=year(date_sub('2022-09-11',10))); {code}



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