Como criar divisões de conjuntos de dados repetíveis no BigQuery v1.5 avaliações

Dhaval V. · Revisado há over 1 year

cheok y. · Revisado há over 1 year

cheok y. · Revisado há over 1 year

ANNA C. · Revisado há over 1 year

Javier B. · Revisado há over 1 year

Yee Leng T. · Revisado há over 1 year

Yew C. · Revisado há over 1 year

issac l. · Revisado há over 1 year

issac l. · Revisado há over 1 year

William M. · Revisado há over 1 year

William B. · Revisado há over 1 year

Siew W. · Revisado há over 1 year

Adam B. · Revisado há over 1 year

nuradlinasofea m. · Revisado há over 1 year

Bryan B. · Revisado há over 1 year

Joe L. · Revisado há over 1 year

YEW Y. · Revisado há over 1 year

Fatih F. · Revisado há over 1 year

Boo Siew K. · Revisado há over 1 year

Sia J. · Revisado há over 1 year

Sky G. · Revisado há over 1 year

Tan C. · Revisado há over 1 year

Brent D. · Revisado há over 1 year

Had to debug an error in the SQL to make the lab work. The ABS(MOD(FARM_FINGERPRINT(CAST(CURRENT_DATE() AS STRING)), 10)) < 8 field was the issue. Since current date function would be the same for all records, it returned 9 for all records. This meant that there were no records in the training dataset! I was able to get through the lab by changing this to FlightDate (the date of the flight in the dataset), but I'm not sure if this was the intent. ABS(MOD(FARM_FINGERPRINT(CAST(FlightDate AS STRING)), 10)) < 8

Tim G. · Revisado há over 1 year

Error running the last part

Chee Keong E. · Revisado há over 1 year