Krisztian Kasa created HIVE-29208: ------------------------------------- Summary: Infinite loop while compiling query with filter predicate containing disjuncts on the same expression Key: HIVE-29208 URL: https://issues.apache.org/jira/browse/HIVE-29208 Project: Hive Issue Type: Bug Components: CBO Reporter: Krisztian Kasa
Repro {code} CREATE TABLE t1 (Date_ STRING); SELECT * FROM t1 WHERE ( ( MINUTE(`date_`) = 2 OR MINUTE(`date_`) = 10 ) OR (MINUTE(`date_`) IS NULL) ); {code} The expression {{MINUTE(`date_`)}} is compared in each disjunct hence search operator is not used -- This message was sent by Atlassian Jira (v8.20.10#820010)