Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Thu, 9 Apr 2015 23:29:12 +0000 (UTC)
From: "Khurram Faraaz (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12819883.1428622109000.47138.1428622152163@Atlassian.JIRA>
In-Reply-To: <JIRA.12819883.1428622109000@Atlassian.JIRA>
References: <JIRA.12819883.1428622109000@Atlassian.JIRA>
 <JIRA.12819883.1428622109655@arcas>
Subject: [jira] [Created] (DRILL-2742) Need to support querying of nested
 JSON arrays
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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)