我正在使用新的BigQuery学习,我对提交数据集的查询由于资源超过而不断失败。我将SQL缩减到以下代码,但仍然失败:
SELECT
commit,
FIRST(repo_name) AS repo_name,
FIRST(author.email) AS author_email,
FIRST(author.time_sec) AS time,
SUM(LENGTH(message)) AS len_commit_msg,
COUNT(difference.new_path) AS num_files
FROM
[bigquery-public-data:gith