[DRILL-2122] Projecting a repeated map after a join fails with an obscure error

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Execution - Data Types
• Assignee: Hanifi Gunes
• Reporter: Rahul Kumar Challapalli
• Created: 30/Jan/15 00:28
• Updated: 21/Apr/15 18:36
• Resolved: 27/Feb/15 21:13

Description

git.commit.id.abbrev=3e33880

Data Set 1:

{
    "uid": 1,
    "events" : [
        { "evnt_id":"e1"}
  ]
}

Data Set 2:

{
  "uid1": 1,
  "transactions" : [
       { "trans_id":"t1"}
  ]
}

Query :

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)

The logs were not helpful in this case:

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).

Explain Plan :

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]]])

Issue Links

• is duplicated by: DRILL-2163 Projecting nested types past join returns invalid result