Interval Join

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

Home > Data Cleaning > Join

Input Properties

PropertyRequirementTypeDefaultDescription
Interval Constant✓Long10Left attri in (right, right + constant)
Include Left Bound✓BooleantrueInclude condition left attri = right attri
Include Right Bound✓BooleantrueInclude condition left attri = right attri
Time interval typeTimeIntervalTypedayYear, 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

Output Ports

PortMode
0Set Snapshot