You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Parth Chandra (JIRA)" <ji...@apache.org> on 2015/04/07 06:53:12 UTC
[jira] [Updated] (DRILL-1576) Can not do select with two fields
(field and nested field)
[ https://issues.apache.org/jira/browse/DRILL-1576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra updated DRILL-1576:
---------------------------------
Fix Version/s: (was: 0.9.0)
1.0.0
> Can not do select with two fields (field and nested field)
> -----------------------------------------------------------
>
> Key: DRILL-1576
> URL: https://issues.apache.org/jira/browse/DRILL-1576
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - ODBC
> Affects Versions: 0.5.0
> Environment: MapR SendBox for Drill, Drill Explorer (ODBC)
> Reporter: Iftissen
> Assignee: Parth Chandra
> Priority: Minor
> Labels: Drill, json, odbc
> Fix For: 1.0.0
>
>
> When I try to do a select in json file from Drill explorer:
> If I select one field, then the result is OK
> If I select two fields (field and its nested field) I get an error:
> ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: select t.user_info, t.user_info.device from `dfs`.`data`.`./nested/clicks/clicks.json` t
> [30024]Query execution error. Details:[
> Failure while running fragment. null [d8a551f4-281b-46a1-891e-037e7b46ff2b]
> ]
> I tested this query in SQLLine and it works fine:
> 0: jdbc:drill:zk=localhost:5181> select t.user_info, t.user_info.device from `dfs`.`data`.`./nested/clicks/clicks.json` t limit 10 ;
> +------------+------------+
> | user_info | EXPR$1 |
> +------------+------------+
> | {"cust_id":22526,"device":"IOS5","state":"il"} | IOS5 |
> | {"cust_id":16368,"device":"AOS4.2","state":"nc"} | AOS4.2 |
> | {"cust_id":21449,"device":"IOS6","state":"oh"} | IOS6 |
> | {"cust_id":20323,"device":"IOS5","state":"oh"} | IOS5 |
> | {"cust_id":15360,"device":"IOS5","state":"ca"} | IOS5 |
> | {"cust_id":15957,"device":"IOS7","state":"sc"} | IOS7 |
> | {"cust_id":20677,"device":"IOS7","state":"ny"} | IOS7 |
> | {"cust_id":23599,"device":"IOS5","state":"ri"} | IOS5 |
> | {"cust_id":16122,"device":"IOS6","state":"fl"} | IOS6 |
> | {"cust_id":15342,"device":"IOS5","state":"ms"} | IOS5 |
> +------------+------------+
> 10 rows selected (1.13 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)