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

During filter push down phase, join conditions are not set properly

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: Planner/Optimizer
    • Labels:
      None

      Description

      See the title.
      You can reproduce with this query.

      default> select
        n1.n_name as supp_nation, n2.n_name as cust_nation, n1.n_nationkey as s_nationkey, n2.n_nationkey as c_nationkey
      from
        nation n1 join nation n2
        on
          n1.n_name = 'FRANCE' and n2.n_name = 'GERMANY'
      UNION ALL
      select
        n1.n_name as supp_nation, n2.n_name as cust_nation, n1.n_nationkey as s_nationkey, n2.n_nationkey as c_nationkey
      from
        nation n1 join nation n2
        on
          n2.n_name = 'FRANCE' and n1.n_name = 'GERMANY'
      

      This query causes an NPE as follow:

      2015-07-31 11:06:38,255 ERROR org.apache.tajo.worker.TaskImpl:
      java.lang.NullPointerException
              at org.apache.tajo.plan.util.PlannerUtil.getJoinKeyPairs(PlannerUtil.java:675)
              at org.apache.tajo.engine.planner.physical.CommonHashJoinExec.<init>(CommonHashJoinExec.java:64)
              at org.apache.tajo.engine.planner.physical.HashJoinExec.<init>(HashJoinExec.java:32)
              at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createBestInnerJoinPlan(PhysicalPlannerImpl.java:439)
              at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createInnerJoinPlan(PhysicalPlannerImpl.java:385)
              at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createJoinPlan(PhysicalPlannerImpl.java:300)
              at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlanRecursive(PhysicalPlannerImpl.java:220)
              at org.apache.tajo.engine.planner.PhysicalPlannerImpl.createPlan(PhysicalPlannerImpl.java:92)
              at org.apache.tajo.worker.TajoQueryEngine.createPlan(TajoQueryEngine.java:40)
              at org.apache.tajo.worker.TaskImpl.run(TaskImpl.java:396)
              at org.apache.tajo.worker.TaskContainer.run(TaskContainer.java:65)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
              at java.util.concurrent.FutureTask.run(FutureTask.java:262)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
              at java.lang.Thread.run(Thread.java:745)
      

        Attachments

          Activity

            People

            • Assignee:
              jihoonson Jihoon Son
              Reporter:
              jihoonson Jihoon Son
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: