[ 
https://issues.apache.org/jira/browse/DRILL-1730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacques Nadeau updated DRILL-1730:
----------------------------------
    Fix Version/s: 0.7.0

> 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
>            Assignee: Hanifi Gunes
>             Fix For: 0.7.0
>
>
> {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)

Reply via email to