You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Hanifi Gunes (JIRA)" <ji...@apache.org> on 2014/11/18 23:49:33 UTC
[jira] [Commented] (DRILL-1730) Exception when selecting a map
field
[ https://issues.apache.org/jira/browse/DRILL-1730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14216972#comment-14216972 ]
Hanifi Gunes commented on DRILL-1730:
-------------------------------------
I am able to query this with no problems repeatedly -even after a star query.
{code:sql}
SELECT attributes FROM dfs.`local`.`yelp_academic_dataset_business.json` LIMIT 1
{code}
Any pointers to replicate the problem? Also does this happen at the current master?
> 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)