You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/04/21 20:36:59 UTC
[jira] [Closed] (DRILL-2122) Projecting a repeated map after a join
fails with an obscure error
[ https://issues.apache.org/jira/browse/DRILL-2122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-2122.
------------------------------------
Verified and added the below testcase
Functional/Passing/flatten_operators/2rows/hash-join/join_project_repmap_DRILL2122.q
> 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)