[ 
https://issues.apache.org/jira/browse/TAJO-570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13886790#comment-13886790
 ] 

Hudson commented on TAJO-570:
-----------------------------

SUCCESS: Integrated in Tajo-master-build #46 (See 
[https://builds.apache.org/job/Tajo-master-build/46/])
TAJO-570: InvalidOperationException in outer join with constant values. 
(hyunsik: 
https://git-wip-us.apache.org/repos/asf?p=incubator-tajo.git&a=commit&h=8d6e3785d1b151456463961109387dd71657a8c6)
* 
tajo-core/tajo-core-backend/src/test/resources/queries/TestJoinQuery/testLeftOuterJoinWithConstantExpr3.sql
* 
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/eval/CastEval.java
* 
tajo-core/tajo-core-backend/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithConstantExpr3.result
* 
tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/query/TestJoinQuery.java
* 
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/LogicalPlanner.java
* CHANGES.txt
* 
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/ExprAnnotator.java
* 
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/rewrite/ProjectionPushDownRule.java
* tajo-common/src/main/java/org/apache/tajo/datum/DatumFactory.java


> 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
>            Assignee: Hyunsik Choi
>             Fix For: 0.8-incubating
>
>         Attachments: TAJO-570.patch, TAJO-570_2.patch
>
>
> {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)

Reply via email to