Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Wed, 4 Feb 2015 19:55:34 +0000 (UTC)
From: "Hanifi Gunes (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.12772469.1423079680000.257114.1423079734943@Atlassian.JIRA>
In-Reply-To: <JIRA.12772469.1423079680000@Atlassian.JIRA>
References: <JIRA.12772469.1423079680000@Atlassian.JIRA>
 <JIRA.12772469.1423079680239@arcas>
Subject: [jira] [Created] (DRILL-2163) Projecting nested types past join
 returns invalid result
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Hanifi Gunes created DRILL-2163:
-----------------------------------

             Summary: Projecting nested types past join returns invalid result
                 Key: DRILL-2163
                 URL: https://issues.apache.org/jira/browse/DRILL-2163
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Hanifi Gunes
            Assignee: Hanifi Gunes
            Priority: Critical


Take the following data files and query:

{code:title=a.json}
{
  "uid": 1,
  "events" : [
    { "evnt_id":"e1"}
  ]
}
{code}


{code:title=b.json}
{
  "uid": 1,
  "transactions" : [
    { "trans_id":"t1"}
  ]
}
{code}

{code}
select t1.events, t2.transactions from dfs.`local`.`2122/a.json` t1, dfs.`local`.`2122/b.json` t2 where t1.uid = t2.uid
{code}

The projection of a nested value coming out of right side of join, {{transactions}} as of b6a3878, reports empty result. 


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)