Fractal Interview Question

Hive joins(not SQL)