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)
