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

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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)