An error was reported today.

error: where in subquery source

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