Error when executing hive statement:

Both left and right aliases encountered in JOIN

Cause of error:

Added inequality condition to join's on condition

resolvent:

Just put the inequality condition in where