Movie Recommendations in BigQuery ML 2.5 avis

GD S. · Examiné il y a plus de 3 ans

Nicholas R. · Examiné il y a plus de 3 ans

Asha Tejaswini G. · Examiné il y a plus de 3 ans

Garvit D. · Examiné il y a plus de 3 ans

Pravandana R. · Examiné il y a plus de 3 ans

Joshua Y. · Examiné il y a plus de 3 ans

King E. · Examiné il y a plus de 3 ans

John D. · Examiné il y a plus de 3 ans

Charlene B. · Examiné il y a plus de 3 ans

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. · Examiné il y a plus de 3 ans

Kamran S. · Examiné il y a plus de 3 ans

Peter C. · Examiné il y a plus de 3 ans

Daniel L. · Examiné il y a plus de 3 ans

Aditya P. · Examiné il y a plus de 3 ans

Francesc G. · Examiné il y a plus de 3 ans

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. · Examiné il y a plus de 3 ans

Luiz P. · Examiné il y a plus de 3 ans

Blaine W. · Examiné il y a plus de 3 ans

Daniel D. · Examiné il y a plus de 3 ans

Fatima E. · Examiné il y a plus de 3 ans

Marek C. · Examiné il y a plus de 3 ans

Tommi N. · Examiné il y a plus de 3 ans

Vivek T. · Examiné il y a plus de 3 ans

Mikhail H. · Examiné il y a plus de 3 ans

Siva C. · Examiné il y a plus de 3 ans