[jira] [Created] (DRILL-3476) Filter on nested element gives wrong results

["Steven Phillips (JIRA)" <ji...@apache.org>]

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)