Re: Top N query

> I does't understand about your solution. Could you please provide exact >query? ... 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 -

Re: Top N query

Hi gopal, Thanks for your response. I does't understand about your solution. Could you please provide exact query? Regards, Ravi On Wed, Jun 3, 2015 at 2:23 PM, Gopal Vijayaraghavan wrote: > Hi, > > This particular case can be handled by a special case of the inner > equijoin. > > > ( recom

Re: Top N query

Hi, This particular case can be handled by a special case of the inner equijoin. > ( recommend_ratings2.movieid = T_0.movieid_0 or >((recommend_ratings2.movieid IS NULL) AND (T_0.movieid_0 IS NULL))) Can be rewritten as a null-safe equi-join (i.e where movieid <=> movieid_0, which is not SQL se

RE: Top N query

conditions as it is very difficult to express such conditions as a map/reduce job. Also, more than two tables can be joined in Hive. Regards Arpita Singh From: Ravisankar Mani [mailto:rrav...@gmail.com] Sent: Wednesday, June 03, 2015 12:17 PM To: user@hive.apache.org Subject: Re: Top N query Hi Arpita

Re: Top N query

Hi Arpita, Inner join working perfectly. But the 'or' condition not supported in inner join. Regards Ravi On Wed, Jun 3, 2015 at 6:39 AM, Arpita SINGH wrote: > Is Inner Join supported by the Hive version you are using ? > > > > Regards > > Arpita Singh > > > > *From:* Ravisank

RE: Top N query

Is Inner Join supported by the Hive version you are using ? Regards Arpita Singh From: Ravisankar Mani [mailto:rrav...@gmail.com] Sent: Wednesday, June 03, 2015 11:29 AM To: user@hive.apache.org Subject: Top N query Hi everyone, "FAILED: SemanticException [Error 10019]: Line 9:5 O