[
https://issues.apache.org/jira/browse/DRILL-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanifi Gunes updated DRILL-2163:
--------------------------------
Description:
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.
was:
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.
> 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)
