Fractal interview question

Hive joins(not SQL)