“超出配额:为此项目扫描了太多的免费查询字节"在Google BigQuery中 [英] "Exceeded quota: too many free query bytes scanned for this project" in Google BigQuery

问题描述

在使用JasperReports Server尝试Google BigQuery之后，从昨天开始我遇到了以上错误.我找不到任何相关信息，因为前100GB应该是免费的，并且BigQuery访问报告说:

API项目的BigQuery资源使用情况 数据分析 2013年1月31日– 2013年2月27日

每天处理的数据 0 MB峰值0.00 MB平均

我还没有达到免费查询/用户/天的限制: API每用户限制使用的可计费限制礼节性限制
BigQuery API 5.0请求/秒/用户
0％每天200,000个请求/天10,000个请求/天

和

API项目的流量报告 要求总数 935 要求/天 856高峰平均33.39

开始日期 2013年1月31日

样品期 28天

我正在尝试为我的大学在一个项目中使用出生率样本数据，这非常紧急.大约一天都工作正常.这些查询是由JasperSoft BigQuery Connector( http://code.google.com/p/jaspersoft-bigquery-datasource/)(使用JasperReport作为主题).

我正在使用以下语句:

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

任何帮助将不胜感激！预先感谢！

解决方案

总结上面和下面的评论，以使他人受益:

• 如果您未启用结算，则使用配额不会显示在开发者控制台中.
• 如果您未启用结算功能，则查看报告页面将显示已使用0GB.
• 除非您启用计费功能，否则每月最多只能查询100GB.
• 启用计费功能后，您可以查询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:

BigQuery Resource Usage for API Project Data Analysis Jan 31, 2013 – Feb 27, 2013

Data Processed Per Day 0 MB Peak 0.00 MB Average

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

and

Traffic Reports for API Project Total requests 935 Requests/day 856 peak 33.39 average

Start Date Jan 31, 2013

Sample Period 28 days

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).

I am using the following statement:

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:

• The quota for your usage doesn't show up in the developer console if you don't enable billing.
• Looking at the reports page will show 0GB used if you don't enable billing.
• Unless you enable billing, you have a limit of 100GB to query per month.
• Enabling billing will enable you to query more than 100GB of data.
• The BigQuery team are working on a fix for the reports page not including queries on data when you haven't enabled billing

这篇关于“超出配额:为此项目扫描了太多的免费查询字节"在Google BigQuery中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！