Join

Operators in the Join category

Operators

Operator	Description
Cartesian Product	Append fields together to get the cartesian product of two inputs
Hash Join	Join two inputs
Interval Join	Join two inputs with left table join key in the range of [right table join key, right table join key + constant value]

Total: 3 operators

Append fields together to get the cartesian product of two inputs

Port	Mode
0	Set Snapshot

Join two inputs

Property	Requirement	Type	Default	Description
Left Input Attribute	✓	String	-	Attribute to be joined on the Left Input
Right Input Attribute	✓	String	-	Attribute to be joined on the Right Input
Join Type	✓	inner, left outer, right outer, full outer	inner	Select the join type to execute

Port	Mode
0	Set Snapshot

Join two inputs with left table join key in the range of [right table join key, right table join key + constant value]

Property	Requirement	Type	Default	Description
Interval Constant	✓	Long	10	Left attri in (right, right + constant)
Include Left Bound	✓	Boolean	true	Include condition left attri = right attri
Include Right Bound	✓	Boolean	true	Include condition left attri = right attri
Time interval type		TimeIntervalType	day	Year, Month, Day, Hour, Minute or Second
Left Input attr	✓	String (integer, long, double, timestamp)	-	Choose one attribute in the left table
Right Input attr	✓	String	-	Choose one attribute in the right table

Port	Mode
0	Set Snapshot