Recomendações de filmes no BigQuery ML 2.5 avaliações

GD S. · Revisado há over 3 years

Nicholas R. · Revisado há over 3 years

Asha Tejaswini G. · Revisado há over 3 years

Garvit D. · Revisado há over 3 years

Pravandana R. · Revisado há over 3 years

Joshua Y. · Revisado há over 3 years

King E. · Revisado há over 3 years

John D. · Revisado há over 3 years

Charlene B. · Revisado há over 3 years

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. · Revisado há over 3 years

Kamran S. · Revisado há over 3 years

Peter C. · Revisado há over 3 years

Daniel L. · Revisado há over 3 years

Aditya P. · Revisado há over 3 years

Francesc G. · Revisado há over 3 years

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. · Revisado há over 3 years

Luiz P. · Revisado há over 3 years

Blaine W. · Revisado há over 3 years

Daniel D. · Revisado há over 3 years

Fatima E. · Revisado há over 3 years

Marek C. · Revisado há over 3 years

Tommi N. · Revisado há over 3 years

Vivek T. · Revisado há over 3 years

Mikhail H. · Revisado há over 3 years

Siva C. · Revisado há over 3 years