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; |
Wednesday 8 August 2018
Movie Recommendation engine using SQL
Subscribe to:
Posts (Atom)
-
Creating a connection Note: config values passed from SparkSubmitOperator takes precedence over the connection parameters. ... -
Reflect function: A Java class and method often exists to handle the exact function a user would like to use in Hive. Rather than having ...
-
Spark setup: Install Java and Python Download spark from here and extract to a directory C:\ spark-2.3.1-bin-hadoop2.7 Clone the GIT repo...