[ https://issues.apache.org/jira/browse/DRILL-1059?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14382944#comment-14382944 ]
Victoria Markman commented on DRILL-1059: ----------------------------------------- My mistake, back to the "Future" :) > 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: Execution - Relational Operators > Reporter: Zhiyong Liu > Fix For: Future > > > 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.3.4#6332)