Tomer Shiran created DRILL-1730:
-----------------------------------
Summary: Exception when selecting a map field
Key: DRILL-1730
URL: https://issues.apache.org/jira/browse/DRILL-1730
Project: Apache Drill
Issue Type: Bug
Reporter: Tomer Shiran
{code}
0: jdbc:drill:zk=localhost:2181> SELECT * FROM
dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json` LIMIT 1;
+-------------+--------------+------------+------------+------------+------------+--------------+------------+------------+------------+------------+------------+------------+------------+---------------+
| business_id | full_address | hours | open | categories | city
| review_count | name | longitude | state | stars | latitude
| attributes | type | neighborhoods |
+-------------+--------------+------------+------------+------------+------------+--------------+------------+------------+------------+------------+------------+------------+------------+---------------+
| vcNAWiLM4dR7D2nwwJ7nCA | 4840 E Indian School Rd
Ste 101
Phoenix, AZ 85018 |
{"Tuesday":{"close":"17:00","open":"08:00"},"Friday":{"close":"17:00","open":"08:00"},"Monday":{"close":"17:00","open":"08:00"},"Wednesday":{"close":"17:00","open":"08:00"},"Thursday":{"close":"17:00","open":"08:00"},"Sunday":{},"Saturday":{}}
| true | ["Doctors","Health & Medical"] | Phoenix | 7 |
Eric Goldberg, MD | -111.983758 | AZ | 3.5 | 33.499313 | {"By
Appointment Only":true,"Good
For":{},"Ambience":{},"Parking":{},"Music":{},"Hair Types Specialized
In":{},"Payment Types":{},"Dietary Restrictions":{}} | business | []
|
+-------------+--------------+------------+------------+------------+------------+--------------+------------+------------+------------+------------+------------+------------+------------+---------------+
1 row selected (0.204 seconds)
0: jdbc:drill:zk=localhost:2181> SELECT attributes FROM
dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json` LIMIT 1;
Query failed: Failure while running fragment.[
4e82c23c-0181-4164-a1ae-f2d3f9be24d9 on 172.19.128.211:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
0: jdbc:drill:zk=localhost:2181>
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
