You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2015/04/02 19:38:53 UTC

[jira] [Assigned] (DRILL-2163) Projecting nested types past join returns invalid result

     [ https://issues.apache.org/jira/browse/DRILL-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chun Chang reassigned DRILL-2163:
---------------------------------

    Assignee: Chun Chang  (was: Parth Chandra)

> 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
>          Components: Execution - Data Types
>            Reporter: Hanifi Gunes
>            Assignee: Chun Chang
>            Priority: Critical
>             Fix For: 0.8.0
>
>         Attachments: DRILL-2163.1.patch.txt
>
>
> 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)