Creating Repeatable Dataset Splits in BigQuery v1.5 Reviews

Dhaval V. · Reviewed over 1 year ago

cheok y. · Reviewed over 1 year ago

cheok y. · Reviewed over 1 year ago

ANNA C. · Reviewed over 1 year ago

Javier B. · Reviewed over 1 year ago

Yee Leng T. · Reviewed over 1 year ago

Yew C. · Reviewed over 1 year ago

issac l. · Reviewed over 1 year ago

issac l. · Reviewed over 1 year ago

William M. · Reviewed over 1 year ago

William B. · Reviewed over 1 year ago

Siew W. · Reviewed over 1 year ago

Adam B. · Reviewed over 1 year ago

nuradlinasofea m. · Reviewed over 1 year ago

Bryan B. · Reviewed over 1 year ago

Joe L. · Reviewed over 1 year ago

YEW Y. · Reviewed over 1 year ago

Fatih F. · Reviewed over 1 year ago

Boo Siew K. · Reviewed over 1 year ago

Sia J. · Reviewed over 1 year ago

Sky G. · Reviewed over 1 year ago

Tan C. · Reviewed over 1 year ago

Brent D. · Reviewed over 1 year ago

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. · Reviewed over 1 year ago

Error running the last part

Chee Keong E. · Reviewed over 1 year ago