Joins

Introduction

This feature allows a join between 2 or more datasets. This join could be one of the following types

• inner join - return rows that have matching values in both the datasets

• full outer join - returns all records from left and right dataset even when there aren't matching rows

• left outer join - returns all records from the left dataset and the matching ones from the right side dataset. Right side dataset returns null values for rows on the left that didn't match

• right outer join - returns all records from the right dataset and the matching ones from the left side dataset. Left side dataset returns null values for rows on the right that didn't match

• fuzzy join

• cross join - also known as cartesian join. It gives cartesian product of the 2 datasets