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/02/04 23:19:34 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14306094#comment-14306094 ]
Chun Chang commented on DRILL-2163:
-----------------------------------
Looks like both left and right side are all empty for complex types:
{code}
0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select a.id, a.soa, b.sfa[0], b.soa[1] from `complex.json` a inner join `complex.json` b on a.sia[0]=b.sia[0] order by a.id limit 20;
+------------+------------+------------+------------+
| id | soa | EXPR$2 | EXPR$3 |
+------------+------------+------------+------------+
| 1 | [{},{},{},{}] | 0.0 | {} |
| 2 | [{},{},{},{}] | 0.0 | {} |
| 3 | [{},{},{},{}] | 0.0 | {} |
| 4 | [{},{},{},{}] | 0.0 | {} |
| 5 | [{},{},{},{}] | 0.0 | {} |
| 6 | [{},{},{},{}] | 0.0 | {} |
| 7 | [{},{},{},{}] | 0.0 | {} |
| 8 | [{},{},{},{}] | 0.0 | {} |
| 9 | [{},{},{},{}] | 0.0 | {} |
| 10 | [{},{},{},{}] | 0.0 | {} |
| 11 | [{},{},{},{}] | 0.0 | {} |
| 12 | [{},{},{},{}] | 0.0 | {} |
| 13 | [{},{},{},{}] | 0.0 | {} |
| 14 | [{},{},{},{}] | 0.0 | {} |
| 15 | [{},{},{},{}] | 0.0 | {} |
| 16 | [{},{},{},{}] | 0.0 | {} |
| 17 | [{},{},{},{}] | 0.0 | {} |
| 18 | [{},{},{},{}] | 0.0 | {} |
| 19 | [{},{},{},{}] | 0.0 | {} |
| 20 | [{},{},{},{}] | 0.0 | {} |
+------------+------------+------------+------------+
20 rows selected (34.464 seconds)
{code}
> 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)