google-bigquery - 从 Google 公共数据集中提取特定年份的数据 - chicago_taxi_trips

Question

我正在尝试从谷歌公共数据集-chicago_taxi_trips中提取数据，因为数据集很大，我只想提取 2012 年和 2018 年的数据

我正在使用下面的查询来提取我需要的列，但我无法使用我用 sql 函数WHERE Year = 2012 OR Year = 2018创建的列来提取它Year

SELECT trip_start_timestamp, 
EXTRACT(year FROM trip_start_timestamp) as Year, 
EXTRACT(month FROM trip_start_timestamp) as Month, 
EXTRACT(day FROM trip_start_timestamp) as Day,
EXTRACT(DAYOFWEEK FROM trip_start_timestamp) as Weekday,
EXTRACT(Week FROM trip_start_timestamp) as Week,
EXTRACT(hour FROM trip_start_timestamp) as Hour, trip_end_timestamp, trip_seconds, trip_miles, fare, tips, tolls, extras, 
trip_total, payment_type, company
FROM `bigquery-public-data.chicago_taxi_trips.taxi_trips`
WHERE Year = 2012 OR Year = 2018

我应该如何更改我的代码才能使其正常工作？

标签： google-bigquerytimestampfiltering

Answer 1

只需更换

WHERE Year = 2012 OR Year = 2018    

和

WHERE EXTRACT(year FROM trip_start_timestamp) IN (2012, 2018)