Chiran Ravani created HIVE-26320: ------------------------------------ Summary: Incorrect case evaluation for Parquet based table. Key: HIVE-26320 URL: https://issues.apache.org/jira/browse/HIVE-26320 Project: Hive Issue Type: Improvement Components: HiveServer2, Query Planning Affects Versions: 4.0.0-alpha-1 Reporter: Chiran Ravani
Query involving case statement with two or more conditions leads to incorrect result for tables with parquet format, The problem is not observed with ORC or TextFile. *Steps to reproduce*: {code:java} create external table case_test_parquet(kob varchar(2),enhanced_type_code int) stored as parquet; insert into case_test_parquet values('BB',18),('BC',18),('AB',18); select case when ( (kob='BB' and enhanced_type_code='18') or (kob='BC' and enhanced_type_code='18') ) then 1 else 0 end as logic_check from case_test_parquet; {code} Result: {code} 0 0 0 {code} Expected result: {code} 1 1 0 {code} The problem does not appear when setting hive.optimize.point.lookup=false. -- This message was sent by Atlassian Jira (v8.20.7#820007)