[jira] [Created] (TAJO-570) InvalidOperationException in outer join with constant values

[Hyunsik Choi (JIRA)]

Hyunsik Choi created TAJO-570:
---------------------------------

             Summary: InvalidOperationException in outer join with constant 
values
                 Key: TAJO-570
                 URL: https://issues.apache.org/jira/browse/TAJO-570
             Project: Tajo
          Issue Type: Bug
          Components: planner/optimizer
            Reporter: Hyunsik Choi
             Fix For: 0.8-incubating


{code}
select 
  a.name, 
  1::FLOAT, 
  max_id 
from table1 a
left outer join
 (select id, max(type) as max_id from table1 group by id) b
 on a.id = b.id
{code}

The above case causes the following error:

{code}
2014-01-29 14:37:35,419 ERROR worker.Task (Task.java:run(378)) - 
org.apache.tajo.datum.exception.InvalidOperationException: Cannot equivalent 
check: TEXT and INT4
        at org.apache.tajo.datum.TextDatum.equalsTo(TextDatum.java:137)
        at org.apache.tajo.engine.eval.BinaryEval.eval(BinaryEval.java:134)
        at 
org.apache.tajo.engine.planner.physical.HashLeftOuterJoinExec.next(HashLeftOuterJoinExec.java:144)
        at 
org.apache.tajo.engine.planner.physical.HashShuffleFileWriteExec.next(HashShuffleFileWriteExec.java:117)
        at org.apache.tajo.worker.Task.run(Task.java:370)
        at org.apache.tajo.worker.TaskRunner$1.run(TaskRunner.java:392)
        at java.lang.Thread.run(Thread.java:662)
{code}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)