GoogleCloudPlatform/training-data-analyst

Error in courses/machine_learning/deepdive2/launching_into_ml/labs/python.BQ_explore_data.ipynb lab

VeerMuchandi opened this issue · 2 comments

https://github.com/GoogleCloudPlatform/training-data-analyst/blob/master/courses/machine_learning/deepdive2/launching_into_ml/labs/python.BQ_explore_data.ipynb

The queries to BQ to extract trips from the dataset fail

%%bigquery
SELECT
    FORMAT_TIMESTAMP(
        "%Y-%m-%d %H:%M:%S %Z", pickup_datetime) AS pickup_datetime,
    pickup_longitude, pickup_latitude, dropoff_longitude,
    dropoff_latitude, passenger_count, trip_distance, tolls_amount, 
    fare_amount, total_amount 
# TODO 3: Set correct BigQuery public dataset for nyc-tlc yellow taxi cab trips
# Tip: For projects with hyphens '-' be sure to escape with backticks ``
FROM 
LIMIT 10

Here is the error

Could not save output to variable 'trips'.

ERROR:
 _blocking_poll() got an unexpected keyword argument 'retry'

You need to pin down the dependency of the google-cloud-bigquery, please use

!pip install --user google-cloud-bigquery==1.25.0 google-api-core==1.33.2

in cell 2

This is my PR for fixing the issue #2296