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)

Reply via email to