Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Wed, 22 Mar 2017 00:45:41 +0000 (UTC)
From: "Robert Hou (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.13058054.1490143528000.83303.1490143541611@Atlassian.JIRA>
In-Reply-To: <JIRA.13058054.1490143528000@Atlassian.JIRA>
References: <JIRA.13058054.1490143528000@Atlassian.JIRA> <JIRA.13058054.1490143528924@jira-lw-us.apache.org>
Subject: [jira] [Created] (DRILL-5374) Parquet filter pushdown does not
 prune partition with nulls when predicate uses float column
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 22 Mar 2017 00:45:51 -0000

Robert Hou created DRILL-5374:
---------------------------------

             Summary: Parquet filter pushdown does not prune partition with nulls when predicate uses float column
                 Key: DRILL-5374
                 URL: https://issues.apache.org/jira/browse/DRILL-5374
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 1.9.0
            Reporter: Robert Hou
            Assignee: Jinfeng Ni


Drill does not prune enough partitions for this query when filter pushdown is used with metadata caching. The float column is being compared with a double value.

{code}
0: jdbc:drill:zk=10.10.100.186:5181/drill/rho> select count(*) from orders_parts_metadata where float_id < 1100.0;
{code}

To reproduce the problem, put the attached files into a directory. Then 

{code}
create the metadata:
refresh table metadata dfs.`path_to_directory`;
{code}

For example, if you put the files in /drill/testdata/filter/orders_parts_metadata, then run this sql command

{code}
refresh table metadata dfs.`/drill/testdata/filter/orders_parts_metadata`;
{code}


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)