Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 03A15174AB for ; Fri, 6 Feb 2015 19:19:38 +0000 (UTC) Received: (qmail 97259 invoked by uid 500); 6 Feb 2015 19:19:35 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 97226 invoked by uid 500); 6 Feb 2015 19:19:34 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 97129 invoked by uid 99); 6 Feb 2015 19:19:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Feb 2015 19:19:34 +0000 Date: Fri, 6 Feb 2015 19:19:34 +0000 (UTC) From: "Jinfeng Ni (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-2094) Drill has problems with reading json fields when used in a subquery MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2094: ------------------------------ Fix Version/s: 1.0.0 > Drill has problems with reading json fields when used in a subquery > ------------------------------------------------------------------- > > Key: DRILL-2094 > URL: https://issues.apache.org/jira/browse/DRILL-2094 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning & Optimization > Reporter: Rahul Challapalli > Assignee: Jinfeng Ni > Fix For: 1.0.0 > > > git.commit.id.abbrev=3e33880 > Data Set : > {code} > { > "id" : 1, > "list" : [1,2] > } > {code} > The below query works > {code} > 0: jdbc:drill:schema=dfs.drillTestDir> select id from `temp1.json` order by list[0]; > +------------+ > | id | > +------------+ > | 1 | > +------------+ > 1 row selected (0.146 seconds) > {code} > However when I used the same exact query as part of a sub-query, I get an error from drill > {code} > 0: jdbc:drill:schema=dfs.drillTestDir> select s.id from (select id from `temp1.json` order by list[0]) s; > Query failed: SqlValidatorException: Table 'list' not found > Error: exception while executing query: Failure while executing query. (state=,code=0) > {code} > Explain plan also does not work and it returns the same problem -- This message was sent by Atlassian JIRA (v6.3.4#6332)