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; |
Subscribe to:
Post Comments (Atom)
-
Few more questions.. Happy Reading 1.Explain how Hadoop is different from other parallel computing solutions. 2.What are the modes ...
-
Creating a connection Note: config values passed from SparkSubmitOperator takes precedence over the connection parameters. ... -
Spark is a distributed in memory (mostly) computing framework/processing engine designed for batch and streaming data featuring SQL querie...
No comments:
Post a Comment