Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
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)