[
https://issues.apache.org/jira/browse/DRILL-2122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hanifi Gunes resolved DRILL-2122.
---------------------------------
Resolution: Fixed
fixed by DRILL-2163
> Projecting a repeated map after a join fails with an obscure error
> ------------------------------------------------------------------
>
> Key: DRILL-2122
> URL: https://issues.apache.org/jira/browse/DRILL-2122
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Reporter: Rahul Challapalli
> Assignee: Hanifi Gunes
> Priority: Blocker
> Fix For: 0.9.0
>
>
> git.commit.id.abbrev=3e33880
> Data Set 1:
> {code}
> {
> "uid": 1,
> "events" : [
> { "evnt_id":"e1"}
> ]
> }
> {code}
> Data Set 2:
> {code}
> {
> "uid1": 1,
> "transactions" : [
> { "trans_id":"t1"}
> ]
> }
> {code}
> Query :
> {code}
> select t1.uid, t1.events from `data1.json` t1, `data2.json` t2 where t1.uid
> = t2.uid1;
> Error: exception while executing query: null (state=,code=0)
> {code}
> The logs were not helpful in this case:
> {code}
> 2015-01-29 23:12:54,474 [2b354189-5439-e82d-e85e-3728b466c6dc:foreman] INFO
> o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING -->
> RUNNING
> 2015-01-29 23:12:54,532 [UserServer-1] INFO
> o.a.drill.exec.work.foreman.Foreman - State change requested. RUNNING -->
> CANCELED
> 2015-01-29 23:12:54,542 [UserServer-1] INFO
> o.a.drill.exec.work.foreman.Foreman - State change requested. CANCELED -->
> COMPLETED
> 2015-01-29 23:12:54,543 [UserServer-1] WARN
> o.a.drill.exec.work.foreman.Foreman - Dropping request to move to COMPLETED
> state as query is already at CANCELED state (which is terminal).
> {code}
> Explain Plan :
> {code}
> 00-00 Screen
> 00-01 Project(uid=[$0], events=[$1])
> 00-02 Project(uid=[$0], events=[$1])
> 00-03 HashJoin(condition=[=($0, $2)], joinType=[inner])
> 00-05 Project(uid=[$1], events=[$0])
> 00-06 Scan(groupscan=[EasyGroupScan
> [selectionRoot=/drill/testdata/flatten_operators/data1.json, numFiles=1,
> columns=[`uid`, `events`],
> files=[maprfs:/drill/testdata/flatten_operators/temp3.json]]])
> 00-04 Scan(groupscan=[EasyGroupScan
> [selectionRoot=/drill/testdata/flatten_operators/data2.json, numFiles=1,
> columns=[`uid1`],
> files=[maprfs:/drill/testdata/flatten_operators/temp4.json]]])
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
