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] [Updated] (DRILL-1244) "Index out of bound Exception" with Null arrays in JSON for certain result set size
Date Mon, 11 Aug 2014 21:52:17 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sudheesh Katkam updated DRILL-1244:
-----------------------------------

    Due Date: 11/Aug/14

> "Index out of bound Exception" with Null arrays in JSON  for certain result set size
> ------------------------------------------------------------------------------------
>
>                 Key: DRILL-1244
>                 URL: https://issues.apache.org/jira/browse/DRILL-1244
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>    Affects Versions: 0.4.0
>            Reporter: Neeraja
>            Assignee: Hanifi Gunes
>
> Certain queries on a JSON dataset throwing "Index out of bounds exception" errors when
they process null arrays. The Null arrays are just returned fine when a variation of the query
is attempted in such a way that different number of records are returned.
> The specific query that reproduces the issue is below.
> SELECT t.marketing_info.keywords FROM dfs.`/home/mapr/mobile.json` t where t.trans_info.purch_flag
like 'true' and t.user_info.state like 'wa' 
> The issue seem to be occurring in the record below (note the empty keyword array). Modifying
the keywords field to add a entry fixes the issue.
> {"trans_id":10710,"date":"07/19/2013","time":"13:27:22","user_info":{"cust_id":38533,"device":"IOS5","state":"wa"},"marketing_info":{"camp_id":1,"keywords":[]},"trans_info":{"prod_id":[104,307],"purch_flag":"true"}}
> Any variation of query done such as below works fine too.
> SELECT t.marketing_info.keywords FROM dfs.`/home/mapr/mobile.json` t where  t.user_info.state
like 'wa' ;
> SELECT t.marketing_info.keywords FROM dfs.`/home/mapr/mobile.json` t where t.trans_info.purch_flag
like 'true' ;
> SELECT t.marketing_info.keywords FROM dfs.`/home/mapr/mobile.json` t ;



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message