Skip to content

Instantly share code, notes, and snippets.

@chribsen

chribsen/create_feature_same_genre_score.sql

Created April 4, 2016 16:31
Show Gist options
  • Save chribsen/b478371778f13da5093efaf2b7194086 to your computer and use it in GitHub Desktop.
Save chribsen/b478371778f13da5093efaf2b7194086 to your computer and use it in GitHub Desktop.
Download ZIP
Creates the feature same_genre_score
Raw
create_feature_same_genre_score.sql
update derived_friend_features set same_genre_score=FALSE;
update derived_friend_features AS fr set same_genre_score = TRUE
where (select itunes_genre FROM tmp_user_genre WHERE user_id = fr.user_a limit 1) = (select itunes_genre FROM tmp_user_genre WHERE user_id = fr.user_b limit 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment