[DRILL-1419] Query against JSON file fails on Drill Sandbox build

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.5.0
• Fix Version/s: 0.6.0
• Component/s: Query Planning & Optimization

Environment

Fails on Drill Sandbox, running 0.5.

Runs on demo cluster:
[mapr@ip-172-16-1-60 drill-0.5.0]$ more git.properties
#Generated by Git-Commit-Id-Plugin
#Mon Aug 18 12:53:44 PDT 2014
git.commit.id.abbrev=654c879

• Assignee: Jason Altekruse
• Reporter: Bob Rumsby
• Created: 14/Sep/14 17:47
• Updated: 01/Oct/14 23:41
• Resolved: 01/Oct/14 23:41

Description

On the Drill Sandbox build from Sept. 12, this query returns:

0: jdbc:drill:> select t.trans_id, t.trans_info.prod_id[0],t.trans_info.prod_id[1]
from `clicks/clicks.json` t limit 5;
Query failed: Screen received stop request sent. null [c61ef116-b9f4-4479-aec7-d21168469cec]

On the demo cluster, this query returns:

0: jdbc:drill:> select t.trans_id, t.trans_info.prod_id[0],t.trans_info.prod_id[1]
. . . . . . . > from `clicks/clicks.json` t limit 5;
--------------------------------

trans_id

EXPR$1

EXPR$2

--------------------------------

31920	174	2
31026	null	null
33848	582	null
32383	710	47
32359	0	8

--------------------------------
5 rows selected (0.207 seconds)