[DRILL-1059] tracking: Full outer join not currently supported with hash join disabled

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Relational Operators
• Assignee: Unassigned
• Reporter: Zhiyong Liu
• Created: 24/Jun/14 17:51
• Updated: 26/Mar/15 23:36

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)