Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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
The above case causes the following error:
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)