Scenario. Rank the companies by country based on their turnover in Hive ? companyName, country, turnover Solution Hive> SELECT companyName, country, turnover, rank() over (PARTITION BY countryORDER BY turnoverDESC)as rank FROM sales;
No comments:
Post a Comment
Note: only a member of this blog may post a comment.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.