SELECT criticid AS criticid, (ROW_NUMBER() Over(order by sum(rating) asc)) as a1 FROM recommend_ratings2 Group by criticid
" SemanticException Failed to breakup Windowing invocations into Groups. At least 1 group must only depend on input columns. Also check for circular dependencies. Underlying error: org.apache.hadoop.hive.ql.parse.SemanticException: Line 3:31 Expression not in GROUP BY key 'rating' Exception occur when using following query. This query woeking fine SELECT recommend_ratings2.criticid AS criticid_0_0, (ROW_NUMBER() Over(order by rating asc)) FROM recommend_ratings2 * but i need to find row number with over with aggregation column.. Could you please kelp regarding this query..* *Regards,* *Ravi *
