[ https://issues.apache.org/jira/browse/DRILL-4482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15185672#comment-15185672 ]
Stefán Baxter commented on DRILL-4482: -------------------------------------- Hi, This is via dfs. The relevant part of the schema is here: {"name": "client_ip", "type": ["null",{"name":"ClientIPEntry", "type":"record", "fields": [ {"name": "ip", "type": "string"}, {"name": "isp", "type": ["null","string"]}, {"name": "postal_code", "type": ["null","string"]}, {"name": "country_code", "type": ["null","string"]}, {"name": "latitude", "type": ["null","double"]}, {"name": "longitude", "type": ["null","double"]} ]}]}, - Stefán On Tue, Mar 8, 2016 at 7:56 PM, Jason Altekruse (JIRA) <j...@apache.org> > Avro no longer selects data correctly from a sub-structure > ---------------------------------------------------------- > > Key: DRILL-4482 > URL: https://issues.apache.org/jira/browse/DRILL-4482 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Avro > Affects Versions: 1.6.0 > Reporter: Stefán Baxter > Assignee: Stefán Baxter > Priority: Blocker > Fix For: 1.6.0 > > > Parquet: > 0: jdbc:drill:zk=local> select s.client_ip.ip from > dfs.asa.`/processed/<>/transactions` as s limit 1; > +----------------+ > | EXPR$0 | > +----------------+ > | 87.55.171.210 | > +----------------+ > 1 row selected (1.184 seconds) > Avro: > 0: jdbc:drill:zk=local> select s.client_ip.ip from > dfs.asa.`/streaming/<>/transactions` as s limit 1; > +---------+ > | EXPR$0 | > +---------+ > | null | > +---------+ > 1 row selected (0.29 seconds) -- This message was sent by Atlassian JIRA (v6.3.4#6332)