search

sijocherian / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

Error message "Cannot process data in separate locations" #270

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
> What steps will reproduce the problem?

Today trying to load csv file to BigQuery from Google Cloud 
Storage(https://bigquery.cloud.google.com/jobs/xxxx). 
But often occurs error. Error message is "Cannot process data in separate 
locations". 

What does "Cannot process data in separate locations" mean?

This occurs from today(2015/06/25 JST)

> Please provide any additional information below.

Attached image

Original issue reported on code.google.com by hosh...@feedforce.jp on 25 Jun 2015 at 5:11

Attachments:

GoogleCodeExporter commented 9 years ago 
In this release, we enabled a feature to disallow pipeline import/export across 
regions. It turned out many projects are accessing out of US GCS data. During 
the brief time, 48 projects are affected (2961 out of total failed 3791 jobs 
because of this). We don't want to impact existing projects too much and we 
want to allow data in US GCS to be imported into EU as a EU bootstrap. So the 
decision is to disable the checking.
https://critique.corp.google.com/#review/96894527

Original comment by y...@google.com on 25 Jun 2015 at 8:10

GoogleCodeExporter commented 9 years ago 
Note: the https://critique.corp.google.com/ link in #2 is some extra 
information that's isn't visible outside Google.  Please disregard it.

Original comment by marain@google.com on 26 Jun 2015 at 11:07

GoogleCodeExporter commented 9 years ago 
This error is currently not occurring for external users, only occurring to our 
internal testing projects that are triggering it deliberately in known cases.

Marking as fixed.  If anyone sees this in a situation where it doesn't make 
sense, please let us known.

Original comment by e...@google.com on 1 Jul 2015 at 7:01

GoogleCodeExporter commented 9 years ago 
thx!

Original comment by hosh...@feedforce.jp on 2 Jul 2015 at 9:36

GoogleCodeExporter commented 9 years ago 
I need to make a selection from table1 and write it to a table2. Both tables 
are located in EU datasets.
If I run a query from web interface - it works.
If I use API - job fails with 'Cannot process data in separate locations'.

What am I doing wrong?

Original comment by igor.l.s...@gmail.com on 14 Aug 2015 at 4:57

GoogleCodeExporter commented 9 years ago 
Can you provide job IDs for the successful and unsuccessful queries?

Original comment by jcon...@google.com on 14 Aug 2015 at 6:01