Solution : Get details of top 5 customers by revenue for each month


Hi All ,

for the above exercise 6, i have few doubts…kindly clarify me…

  1. Should create DB in hive.
  2. create all the needed tables in Hive DB.
  3. using either hive ql or spark ql, we can make transformations.

this problem expects to use rank() function? just clarify me please