drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefán Baxter (JIRA) <j...@apache.org>
Subject [jira] [Commented] (DRILL-4482) Avro no longer selects data correctly from a sub-structure
Date Tue, 08 Mar 2016 18:29:41 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15185439#comment-15185439
] 

Stefán Baxter commented on DRILL-4482:
--------------------------------------

Still behaves the same.

This query is getting the *same records* from the *same Avro* file just:

0: jdbc:drill:zk=local> select *s.client_ip* from
dfs.asa.`/streaming/venuepoint/transactions` as s limit 2;
+-------------------------------------------------------------------------------------------------------------------+
                                        |
+-------------------------------------------------------------------------------------------------------------------+
{"ip":"77.106.147.165","postal_code":"2601","country_code":"NO","latitude":61.1151,"longitude":10.4663}
          |
{"ip":"unknown","postal_code":"unknown","country_code":"unknown","latitude":0.0,"longitude":0.0,"isp":"unknown"}
 |
+-------------------------------------------------------------------------------------------------------------------+
2 rows selected (0.39 seconds)

0: jdbc:drill:zk=local> select s.*client_ip.ip* from
dfs.asa.`/streaming/venuepoint/transactions` as s limit 2;
+---------+
+---------+
+---------+
2 rows selected (0.16 seconds)

Notice what happens wen a reference to the the sub field is added.

Regards,
 -Stefán

On Tue, Mar 8, 2016 at 6:08 PM, Jason Altekruse (JIRA) <jira@apache.org>
wrote:



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

Mime
View raw message