Apache Drill
  1. Apache Drill
  2. DRILL-1059

tracking: Full outer join not currently supported with hash join disabled

    Details

      Description

      git.commit.id.abbrev=79c1502
      git.commit.id=79c1502c1e96596d4db302c2dd1c9f78d0f4d43d

      0: jdbc:drill:schema=dfs> alter session set `planner.enable_hashjoin` = false;
      ----------------------+

      ok summary

      ----------------------+

      true planner.enable_hashjoin updated.

      ----------------------+
      1 row selected (0.075 seconds)
      0: jdbc:drill:schema=dfs> select store.store_id, store.store_name, store.store_city, store.store_state, store.store_postal_code, store.store_country, region.region_id, region.sales_city from store full outer join region on store.region_id = region.region_id order by region.region_id;
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "008e5aec-3e70-42e3-9b45-74bc5f733ae0"
      endpoint

      { address: "perfnode104.perf.lab" user_port: 31010 control_port: 31011 data_port: 31012 }

      error_type: 0
      message: "Failure while parsing sql. < IllegalArgumentException:[ Full outer join not currently supported ]"
      ]
      Error: exception while executing query (state=,code=0)

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Zhiyong Liu
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development