You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/01/30 01:29:36 UTC
[jira] [Created] (DRILL-2122) Projecting a repeated map after a
join fails with an obscure error
Rahul Challapalli created DRILL-2122:
----------------------------------------
Summary: 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
Reporter: Rahul Challapalli
Assignee: Hanifi Gunes
Priority: Critical
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)