Zhiyong Liu created DRILL-1059:
----------------------------------
Summary: tracking: Full outer join not currently supported with
hash join disabled
Key: DRILL-1059
URL: https://issues.apache.org/jira/browse/DRILL-1059
Project: Apache Drill
Issue Type: New Feature
Components: Functions - Drill
Reporter: Zhiyong Liu
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)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
