drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sudheesh Katkam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2140) RPC Error querying JSON with empty nested maps
Date Wed, 22 Apr 2015 17:47:58 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14507533#comment-14507533
] 

Sudheesh Katkam commented on DRILL-2140:
----------------------------------------

Also, since DRILL-2675 is resolved, can you please retry the query and report the error message?

> RPC Error querying JSON with empty nested maps
> ----------------------------------------------
>
>                 Key: DRILL-2140
>                 URL: https://issues.apache.org/jira/browse/DRILL-2140
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Relational Operators
>    Affects Versions: 0.7.0
>         Environment: Centos 4 node MapR cluster
>            Reporter: Andries Engelbrecht
>            Assignee: Sudheesh Katkam
>             Fix For: 1.0.0
>
>         Attachments: drillbit.log
>
>
> When querying large number of documents in multiple directories with multiple JSON files
in each, and some documents have no top level map that is used for a predicate, Drill produces
a RPC error in the log.
> Query
> {code}
> > select t.retweeted_status.`user`.name as name, count(t.retweeted_status.favorited)
as rt_count from `./nfl` t where t.retweeted_status.`user`.name is not null group by t.retweeted_status.`user`.name
order by count(t.retweeted_status.favorited) desc limit 10;
> Query failed: Query failed: Failure while running fragment., index: 0, length: 1 (expected:
range(0, 0)) [ b96e3bfa-74c9-4b78-886b-9a2c3fc4ea9b on se-node13.se.lab:31010 ]
> [ b96e3bfa-74c9-4b78-886b-9a2c3fc4ea9b on se-node13.se.lab:31010 ]
> {code}
> Drillbit log attached



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message