You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Steven Phillips (JIRA)" <ji...@apache.org> on 2015/04/10 22:33:13 UTC
[jira] [Updated] (DRILL-2742) Need to support querying of nested
JSON arrays
[ https://issues.apache.org/jira/browse/DRILL-2742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Phillips updated DRILL-2742:
-----------------------------------
Fix Version/s: Future
> 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
> Fix For: Future
>
>
> 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)