drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andries Engelbrecht (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2140) RPC Error querying JSON with empty nested maps
Date Mon, 02 Feb 2015 18:14:35 GMT
Andries Engelbrecht created DRILL-2140:
------------------------------------------

             Summary: 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 - RPC
    Affects Versions: 0.7.0
         Environment: Centos 4 node MapR cluster
            Reporter: Andries Engelbrecht
            Assignee: Jacques Nadeau


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

Screen Error
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 ]

Drillbit log attached



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

Mime
View raw message