[moviescore-prediction-bqmlsql]

[amanrc2803]

Predict movie rating using ML.PREDICT The following query predicts the score of each movie in the PREDICT portion of the dataset. Please correct the lab docs. in the dataset we don't have any " PREDICT" Category columns for prediction. there is a some typo error.

SELECT * FROM ML.PREDICT (MODEL movies.movies_score_model, ( SELECT * FROM movies.movies_score WHERE data_cat= 'PREDICT' ) )

instead of data_cat= 'PREDICT' we can add data_cat= 'TEST'.