where in subquery source [How to Solve]

An error was reported today.

error: where in subquery source

Reason:

This is actually because all subqueries in hive need to be aliased

Read More: