“超出配额:为此项目扫描的免费查询字节过多"在 Google BigQuery 中 [英] "Exceeded quota: too many free query bytes scanned for this project" in Google BigQuery
问题描述
在使用 JasperReports Server 试用 Google BigQuery 后,我从昨天开始收到上述错误.我找不到这方面的任何信息,因为前 100GB 应该是免费的,而 BigQuery 访问报告说:
I'm getting the above error since yesterday, after trying out Google BigQuery with JasperReports Server. I couldn't find any info on this, since the first 100GB should be free and the BigQuery Access Report is saying:
API 项目的 BigQuery 资源使用情况数据分析2013 年 1 月 31 日 – 2013 年 2 月 27 日
BigQuery Resource Usage for API Project Data Analysis Jan 31, 2013 – Feb 27, 2013
每天处理的数据0 MB 峰值 0.00 MB 平均值
Data Processed Per Day 0 MB Peak 0.00 MB Average
我也没有达到免费查询/用户/天的限制:API 每用户限制使用的计费限制礼貌限制
BigQuery API 5.0 请求/秒/用户
0% 200,000 个请求/天 10,000 个请求/天
I haven't reached the free query/user/day limit either:
API Per-User Limit Used Billable Limit Courtesy Limit
BigQuery API 5.0 requests/second/user
0% 200,000 requests/day 10,000 requests/day
和
API 项目的流量报告请求总数935请求/天856 峰值 33.39 平均值
Traffic Reports for API Project Total requests 935 Requests/day 856 peak 33.39 average
开始日期2013 年 1 月 31 日
Start Date Jan 31, 2013
采样周期28天
我正在尝试在我大学的一个项目中使用出生样本数据,这非常紧急.它工作了一天左右.查询由 JasperSoft BigQuery 连接器 (http://code.google.com/p/jaspersoft-bigquery-datasource/) 使用 Ad-hoc-View(基于 JasperReport 作为主题).
I'm trying to use the natality sample data in a project for my university and it's pretty urgent. It was working fine for a day or so. The queries are made by the JasperSoft BigQuery Connector (http://code.google.com/p/jaspersoft-bigquery-datasource/) using an Ad-hoc-View (based on a JasperReport as Topic).
我正在使用以下语句:
SELECT
STRING($P!{dimension1}) as dimension_1,
STRING($P!{dimension2}) as dimension_2,
SUM(record_weight) as count_group,
AVG(weight_pounds) as avg_weight_pounds,
AVG(apgar_1min) as apgar_1min,
AVG(apgar_5min) as apgar_5min
FROM publicdata:samples.natality
WHERE
year >= $P!{year_first}
AND year <= $P!{year_last}
GROUP BY dimension_1, dimension_2
ORDER BY dimension_1, dimension_2
任何帮助将不胜感激!提前致谢!
Any help would be highly appreciated! Thanks in advance!
推荐答案
总结上面和下面的评论以供其他人受益:
Summarising the comments above and below for anyone else's benefit:
- 如果您不启用计费,则您的使用配额不会显示在开发者控制台中.
- 如果您不启用计费,查看报告页面将显示 0GB 已使用.
- 除非您启用计费,否则每月查询的限制为 100GB.
- 启用计费将使您能够查询超过 100GB 的数据.
- BigQuery 团队正在修复报告页面,在您未启用结算功能时不包括对数据的查询
这篇关于“超出配额:为此项目扫描的免费查询字节过多"在 Google BigQuery 中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!