Bob Rumsby created DRILL-1419:
---------------------------------
Summary: Query against JSON file fails on Drill Sandbox build
Key: DRILL-1419
URL: https://issues.apache.org/jira/browse/DRILL-1419
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 0.5.0
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
Reporter: Bob Rumsby
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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
