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

["Chris Westin (JIRA)" <ji...@apache.org>]

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

Chris Westin commented on DRILL-2140:
-------------------------------------

The log shows an IndexOutOfBoundsException while attempting to access a DrillBuf in side a filter.

> 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 - Flow
>    Affects Versions: 0.7.0
>         Environment: Centos 4 node MapR cluster
>            Reporter: Andries Engelbrecht
>            Assignee: Chris Westin
>             Fix For: 0.9.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
> 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)