You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/04/10 01:29:12 UTC
[jira] [Created] (DRILL-2742) Need to support querying of nested
JSON arrays
Khurram Faraaz created DRILL-2742:
-------------------------------------
Summary: Need to support querying of nested JSON arrays
Key: DRILL-2742
URL: https://issues.apache.org/jira/browse/DRILL-2742
Project: Apache Drill
Issue Type: Improvement
Components: Storage - JSON
Affects Versions: 0.9.0
Environment: 0.9.0 on CentOS 4 node cluster
| 9d92b8e319f2d46e8659d903d355450e15946533 | DRILL-2580: Exit early from HashJoinBatch if build side is empty | 26.03.2015 @ 16:13:53 EDT
Reporter: Khurram Faraaz
Assignee: Steven Phillips
Priority: Minor
We need to support querying of nested JSON arrays. On 0.9.0 with `store.json.all_text_mode`=true and querying the below nested JSON data results in an Exception. This needs to be supported as it is valid JSON.
{code}
We see the below Exception
0: jdbc:drill:> select * from `nestdJsnArry.json`;
Query failed: Query stopped., Needed to be in state INIT or IN_LIST but in mode IN_VARCHAR [ 9f47bfe8-b8b5-492a-bff1-cf8a5228b657 on centos-02.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query. (state=,code=0)
Data used in the test was
{
"outkey": [
[
1,
2,
3,
-1,
0,
9999,
99999999,
10
],
[
"a",
"p",
"d",
"e",
"w",
"o"
],
[
"string1",
"string2",
"string3",
"longer string",
"this is a test string"
],
[
[
-1,
0,
10,
9999999,
99999,
879,
-5678
],
[
"a",
null
]
]
]
}
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)