hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gopal Vijayaraghavan <>
Subject Re: Top N query
Date Thu, 04 Jun 2015 21:55:58 GMT

> I does't understand about your solution. Could you please provide exact

 GROUP BY recommend_ratings2.movieid  ORDER BY Measure_0 DESC limit 2 ) T_0
ON ( recommend_ratings2.movieid <=> T_0.movieid_0)

Follow the docs on the mysql impl of the space-ship operator -

The hive impl follows the same rules which is (a.x = b.x) OR (a.x is NULL
and b.x is NULL).

AFAIK, most of the complex optimizations are turned off in the presence of
null-safe operators.


View raw message