drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Richard Henderson (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4594) Incorrect results when querying AVRO data with record and array in schema
Date Thu, 07 Apr 2016 22:09:25 GMT
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)

Mime
View raw message