drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Iftissen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1576) Can not do select with two fields (field and nested field)
Date Fri, 24 Oct 2014 14:15:33 GMT
Iftissen created DRILL-1576:
-------------------------------

             Summary: 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


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)

Mime
View raw message