Movie Recommendations in BigQuery ML 2.5 Reviews

GD S. · Reviewed أكثر من 3 سنوات ago

Nicholas R. · Reviewed أكثر من 3 سنوات ago

Asha Tejaswini G. · Reviewed أكثر من 3 سنوات ago

Garvit D. · Reviewed أكثر من 3 سنوات ago

Pravandana R. · Reviewed أكثر من 3 سنوات ago

Joshua Y. · Reviewed أكثر من 3 سنوات ago

King E. · Reviewed أكثر من 3 سنوات ago

John D. · Reviewed أكثر من 3 سنوات ago

Charlene B. · Reviewed أكثر من 3 سنوات ago

some simple big query can not be processed... a bit disappointing: SELECT AVG(predicted_rating) as average_rating, movieId FROM ML.RECOMMEND(MODEL `cloud-training-prod-bucket.movies.movie_recommender`) group by movieId order by movieId LIMIT 100000 Query exceeded resource limits. This query used 24249 CPU seconds but would charge only 43M Analysis bytes. This exceeds the ratio supported by the on-demand pricing model. Please consider moving this workload to the flat-rate reservation pricing model, which does not have this limit. 24249 CPU seconds were used, and this query must use less than 11000 CPU seconds.

Jianing M. · Reviewed أكثر من 3 سنوات ago

Kamran S. · Reviewed أكثر من 3 سنوات ago

Peter C. · Reviewed أكثر من 3 سنوات ago

Daniel L. · Reviewed أكثر من 3 سنوات ago

Aditya P. · Reviewed أكثر من 3 سنوات ago

Francesc G. · Reviewed أكثر من 3 سنوات ago

SELECT * FROM ML.PREDICT(MODEL `cloud-training-prod-bucket.movies.movie_recommender`, ( WITH allUsers AS ( SELECT DISTINCT userId FROM movies.movielens_ratings ) SELECT 96481 AS movieId, ( SELECT title FROM movies.movielens_movies WHERE movieId=96481) title, userId FROM allUsers )) ORDER BY predicted_rating DESC LIMIT 100 it's not working properly with the error Scalar subquery produced more than one element I had to change with SELECT * FROM ML.PREDICT(MODEL `cloud-training-prod-bucket.movies.movie_recommender`, ( WITH allUsers AS ( SELECT DISTINCT userId FROM movies.movielens_ratings ) SELECT 96481 AS movieId, ( SELECT DISTINCT title FROM movies.movielens_movies WHERE movieId=96481) title, userId FROM allUsers )) ORDER BY predicted_rating DESC LIMIT 100

Oussama B. · Reviewed أكثر من 3 سنوات ago

Luiz P. · Reviewed أكثر من 3 سنوات ago

Blaine W. · Reviewed أكثر من 3 سنوات ago

Daniel D. · Reviewed أكثر من 3 سنوات ago

Fatima E. · Reviewed أكثر من 3 سنوات ago

Marek C. · Reviewed أكثر من 3 سنوات ago

Tommi N. · Reviewed أكثر من 3 سنوات ago

Vivek T. · Reviewed أكثر من 3 سنوات ago

Mikhail H. · Reviewed أكثر من 3 سنوات ago

Siva C. · Reviewed أكثر من 3 سنوات ago