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)
