[jira] [Created] (DRILL-2140) RPC Error querying JSON with empty nested maps

["Andries Engelbrecht (JIRA)" <ji...@apache.org>]

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)