Wednesday, 8 August 2018

Movie Recommendation engine using SQL

Data Model


Data Model







Query to get the recommendation:

SELECT f.ID, MVE_ID, IF(AVG(IF(Recommended='Y',1,0))>=0.5,'Y','N')
FROM friend_tbl f LEFT JOIN feedback_tbl fb ON f.Frnd_ID = fb.VIEWER_ID GROUP BY f.ID,MVE_ID;
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

 A good reference for Shell scripting  https://linuxcommand.org/lc3_writing_shell_scripts.php

  • Hadoop Interview Questions 2015 - Part 1
    Few more questions.. Happy Reading 1.Explain how Hadoop is different from other parallel computing solutions. 2.What are the modes ...
  • Airflow SparkSubmitOperator example
    Creating a connection Note: config values passed from SparkSubmitOperator takes precedence over the connection parameters. ...
  • Spark Notes
    Spark is a distributed in memory (mostly) computing framework/processing engine designed for batch and streaming data featuring SQL querie...