[
https://issues.apache.org/jira/browse/DRILL-2140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sudheesh Katkam resolved DRILL-2140.
------------------------------------
Resolution: Fixed
> 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)
