The Repository contains some scala and spark sql programs :
find total number of common friends for any possible friend pairs.
Find top-10 friend pairs by their total number of common friends. For each top-10 friend pair print detail information in decreasing order of total number of common friends. More specifically the output format can be:
List the business_id, full address and categories of the Top 10 mostly-reviewed businesses based on number of users that have rated these businesses.
Top10ReviewBusiness, Top10ReviewBusinessSQL.
List the 'user id' and 'rating' of users that reviewed businesses located in “Palo Alto”