[BEAM-2214] support `JOIN` in explain

• Type: Sub-task
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Fix Version/s: Not applicable
• Component/s: dsl-sql
• Assignee: James Xu
• Reporter: Mingmin Xu
• Created: 08/May/17 16:58
• Updated: 24/Jul/20 20:14
• Resolved: 01/Jul/17 16:42

Description

Support keyword JOIN to to replace node in explain,

LogicalJoin(condition=[=($0, $8)], joinType=[inner|left|right|full])

examples as below:

sql = "select * from ORDER_DETAILS join ORDER_FILTERED_DETAILS on ORDER_DETAILS.f_int = ORDER_FILTERED_DETAILS.f_int";
sql = "select * from ORDER_DETAILS inner join ORDER_FILTERED_DETAILS on ORDER_DETAILS.f_int = ORDER_FILTERED_DETAILS.f_int";
sql = "select * from ORDER_DETAILS left outer join ORDER_FILTERED_DETAILS on ORDER_DETAILS.f_int = ORDER_FILTERED_DETAILS.f_int";
sql = "select * from ORDER_DETAILS right outer join ORDER_FILTERED_DETAILS on ORDER_DETAILS.f_int = ORDER_FILTERED_DETAILS.f_int";

Issue Links

• blocks: BEAM-2215 Beam pipeline for bounded-bounded join
• blocks: BEAM-2216 Beam pipeline for bounded-unbounded join
• blocks: BEAM-2217 Beam pipeline for unbounded-unbounded join