1

More than 5 years have passed since last update.

@munaita_(鈴木省吾)

BigQueryのstandardSQLでexportしようとしたらMaterialize output size (xxxxx) exceeded size limit (134217728)

Posted at 2017-05-16

前提

rubyのgcpのapi(https://github.com/GoogleCloudPlatform/google-cloud-ruby) 使ってます
query_jobでexportしてます

結論

large_results: trueオプションをつければいい


query_job = @api.query_job sql,
       table: result_table,
       standard_sql: true,
       write: 'truncate',
       create: 'never',
       large_results: true, <- これ
       params: params

はまりどこ

standardSQLはAllowLargeResultが常にtrueって書いてあるけど、そんなことなかった
- https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs

1

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

1