You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2016/06/17 13:57:05 UTC
[jira] [Commented] (DRILL-4574) Avro Plugin: Flatten does not work
correctly on record items
[ https://issues.apache.org/jira/browse/DRILL-4574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15336142#comment-15336142 ]
Aman Sinha commented on DRILL-4574:
-----------------------------------
[~baunz] can you rebase your patch on the master branch and push it to the same pull request for inclusion in the 1.7 release ? I would also like someone familiar with the Avro plugin ([~jaltekruse] or [~jnadeau] ?) to comment on whether any functional testing is normally done for avro or are these unit tests sufficient ?
> Avro Plugin: Flatten does not work correctly on record items
> ------------------------------------------------------------
>
> Key: DRILL-4574
> URL: https://issues.apache.org/jira/browse/DRILL-4574
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Avro
> Affects Versions: 1.6.0
> Reporter: Johannes Schulte
> Priority: Minor
>
> If the schema looks like this:
> {code}
> {
> "type" : "record",
> "name" : "MainRecord",
> "namespace" : "drizz.WriteAvroTestFileForDrill$",
> "fields" : [ {
> "name" : "elements",
> "type" : {
> "type" : "array",
> "items" : {
> "type" : "record",
> "name" : "NestedRecord",
> "fields" : [ {
> "name" : "field1",
> "type" : "int"
> } ]
> },
> "java-class" : "java.util.List"
> }
> } ]
> }
> {code}
> and the contents looks like this (according to avro tojson command line utility)
> {code}
> {"elements":[{"field1":0},{"field1":1},{"field1":2},{"field1":3},{"field1":4},{"field1":5},{"field1":6},{"field1":7},{"field1":8},{"field1":9}]}
> {"elements":[{"field1":0},{"field1":1},{"field1":2},{"field1":3},{"field1":4},{"field1":5},{"field1":6},{"field1":7},{"field1":8},{"field1":9}]}
> {code}
> a query like
> select flatten(elements) from dfs.`/Users/j.schulte/data/avro-drill/no-union/`;
> yields exactly two rows:
> {code}
> +---------------+
> | EXPR$0 |
> +---------------+
> | {"field1":9} |
> | {"field1":9} |
> +---------------+
> {code}
> as if only the last element in the array would survive.
> It works for primitive arrays.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)