Mostafa Mokhtar created HIVE-10331: -------------------------------------- Summary: ORC : Is null SARG filters out all row groups written in old ORC format Key: HIVE-10331 URL: https://issues.apache.org/jira/browse/HIVE-10331 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 1.1.0 Reporter: Mostafa Mokhtar Assignee: Prasanth Jayachandran Fix For: 1.2.0
Queries are returning wrong results as all row groups gets filtered out and no rows get scanned. {code} SELECT count(*) FROM store_sales WHERE ss_addr_sk IS NULL {code} With hive.optimize.index.filter disabled we get the correct results -- This message was sent by Atlassian JIRA (v6.3.4#6332)