大查询错误:您的项目超出了已扫描的免费查询字节的配额 [英] Big Query Error: Your project exceeded quota for free query bytes scanned

问题描述

我正在尝试通过大查询的nyc_yellow cabs表访问2015年的记录.而且我一直遇到这个错误.

I am trying to access the records for the year 2015 from the nyc_yellow cabs table on big query. And I keep running into this error.

错误:超出配额:您的项目超出了扫描的免费查询字节的配额.有关更多信息，请参见 https://cloud.google.com/bigquery/troubleshooting-errors.

Error: Quota exceeded: Your project exceeded quota for free query bytes scanned. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors.

我的查询是:

SELECT
  DAYOFWEEK(pickup_datetime) dayofweek,
  INTEGER(100*AVG(trip_distance/((dropoff_datetime-pickup_datetime)/3600000000)))/100 speed,
FROM
  [nyc-tlc:yellow.trips]
  WHERE
  fare_amount/trip_distance between 2
  and 10
  and year(pickup_datetime) = 2015
GROUP BY 1
ORDER BY 1

我正在使用免费试用版.

I am using the Free trial.

推荐答案

每个月您都有1 TB的免费TB来查询BigQuery中的数据-看来您用光了它.

Every month you get 1 free terabyte to query data in BigQuery - it seems you ran out of it.

但是不用担心！它会不断补充，因此您只需要等待几个小时，而不是一个月就可以继续查询.

But don't worry! It replenishes on an ongoing basis, so you only need to wait a couple hours, not a full month to continue querying.

此查询只有33GB，因此每个月您可以免费进行大约30个此类查询.

This query is only 33GB big, so you can do around 30 of these queries for free every month.

仅查看2015年，一种节省配额的方法是使用TLC提供的月度表，如果您将查询更改为仅2015年7月:

As you are only looking at 2015, a way to save quota is to use the monthly tables that the TLC provided, if you change the query to only July 2015:

SELECT DAYOFWEEK(pickup_datetime) dayofweek, INTEGER(100*AVG(trip_distance/((dropoff_datetime-pickup_datetime)/3600000000)))/100 speed, 
FROM [nyc-tlc:yellow.trips_2015_07]
WHERE fare_amount/trip_distance between 2 and 10 
AND year(pickup_datetime) = 2015 
GROUP BY 1 ORDER BY 1

此查询仅处理353MB，因此您每个月可以运行2800个免费查询(更好！).

This one only processes 353MB, so you could run 2,800 free queries like this a month (way better!).

这篇关于大查询错误:您的项目超出了已扫描的免费查询字节的配额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！