[jira] [Created] (DRILL-4594) Incorrect results when querying AVRO data with record and array in schema

["Richard Henderson (JIRA)" <ji...@apache.org>]

Richard Henderson created DRILL-4594:
----------------------------------------

             Summary: Incorrect results when querying AVRO data with record and array in schema
                 Key: DRILL-4594
                 URL: https://issues.apache.org/jira/browse/DRILL-4594
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Avro
    Affects Versions: 1.6.0
            Reporter: Richard Henderson


When querying avro data, if the schema has a record before the array, then the results are incorrect.

Schema:
 { "c_record": {"nested_c_string": "str0"}, "d_array": [{"nested_d_string": "str0"}]}

Query:
select t.c_record, t.d_array[0].nested_d_string from dfs_test.`file.avro` t;

Expected Result:
{"nested_c_string":"str0"}	     str0

Actual Result:
{"nested_c_string":"str0","d_array":[{"nested_d_string":"str0"}]}	null

As you can see, the result is incorrect.  This issue seems to happen only when a record is included before an array in the avro schema.  

However, if the array is included before the record, then the query returns the correct result.  Refer to the following schema:
 { "d_array": [{"nested_d_string": "str0"}], "c_record": {"nested_c_string": "str0"}}




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