Uploaded image for project: '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)

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: