Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-570

InvalidOperationException in outer join with constant values

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.8.0
    • Component/s: Planner/Optimizer
    • Labels:
      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)
      

        Attachments

        1. TAJO-570.patch
          14 kB
          Hyunsik Choi
        2. TAJO-570_2.patch
          14 kB
          Hyunsik Choi

          Activity

            People

            • Assignee:
              hyunsik Hyunsik Choi
              Reporter:
              hyunsik Hyunsik Choi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: