Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
0.5.0
-
MapR SendBox for Drill, Drill Explorer (ODBC)
Description
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)