[
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) <j...@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)
