drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3476) Filter on nested element gives wrong results
Date Thu, 09 Jul 2015 01:24:05 GMT
Steven Phillips created DRILL-3476:
--------------------------------------

             Summary: Filter on nested element gives wrong results
                 Key: DRILL-3476
                 URL: https://issues.apache.org/jira/browse/DRILL-3476
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Steven Phillips


Take this query for example:

{code}
0: jdbc:drill:drillbit=localhost> select * from t;
+----------------+
|       a        |
+----------------+
| {"b":1,"c":1}  |
+----------------+
{code}

if I instead run:

{code}
0: jdbc:drill:drillbit=localhost> select a from t where t.a.b = 1;
+----------------+
|       a        |
+----------------+
| {"b":1}  |
+----------------+
{code}

Only a.b was returned, but the select specified a. In this case, it should have returned all
of the elements of a, not just the one specified in the filter.

This is because the logic in FieldSelection does not correctly handle the case where a selected
column is a child of another selected column. In such a case, the record reader should ignore
the child column, and just return the full selected parent column.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message