Join

Operators in the Join category

Home > Data Cleaning > Join

Operators

OperatorDescription
Cartesian ProductAppend fields together to get the cartesian product of two inputs
Hash JoinJoin two inputs
Interval JoinJoin two inputs with left table join key in the range of [right table join key, right table join key + constant value]

Total: 3 operators


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]