drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hanifi Gunes (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2163) Projecting nested types past join returns invalid result
Date Wed, 04 Feb 2015 19:55:34 GMT
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)

Mime
View raw message