drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hanifi Gunes (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1730) Exception when selecting a map field
Date Mon, 01 Dec 2014 23:10:12 GMT

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

Hanifi Gunes resolved DRILL-1730.
---------------------------------
    Resolution: Cannot Reproduce

The problem does not occur. I tried selecting based on problematic record id as well. As the
field `attributes` of the target record has all empty maps like so 

{"Good For":{},"Ambience":{},"Parking":{},"By Appointment Only":true,"Music":{},"Hair Types
Specialized In":{},"Dietary Restrictions":{}}

I would think the issue related to empty value population and fixed by early commits.

> 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)

Mime
View raw message