[ 
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)

Reply via email to