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)