BigQuery在其他地区之间存在区域限制或延迟？ [英] BigQuery has region restriction or delay between other regions?

问题描述

我想将数据存储在GCE实例的BigQuery上，并从不同的区域实例中查询它。

eg）存储来自EU实例的数据，来自US实例的查询。

这可能会不会有任何延迟吗？

我认为将数据复制到其他区域需要一些时间。

解决方案

BigQuery有区域限制...？

有几个，如下

1. 您不能在欧盟和美国地区之间复制表格。您将得到如下所示的内容
   
   无法在不同位置进行读写：来源：美国，目的地：欧盟



2. 您也无法在相同的查询中查询美国和欧盟的数据。您将得到如下所示的内容
   
   无法处理跨地点的数据：欧盟，美国

我认为将数据复制到其他区域需要一些时间。

执行查询时没有任何复制。你只需要查询它在哪个区域的数据（如果你有权访问的话）

这可能没有任何延迟吗？

因此没有与复制有关的延迟，因为没有复制!!

I want to store data on BigQuery from GCE instance, and query to it from different region instance.
e.g.)store data from EU instance, query from US instance.

Is this possible without any delay?
I think it would take some times to replicate data to other region.

解决方案

BigQuery has region restriction ...?

There are few, like below

1. You cannot copy tables between EU and US regions. You will get something like below
   Cannot read and write in different locations: source: US, destination: EU

2. Also you cannot query data in US and EU within the same query. You will get something like below
   Cannot process data across locations: EU,US

I think it would take some times to replicate data to other region.

There is no any replication when you do query. You just query data where it is / in that region (if you have access of course)

Is this possible without any delay?

Thus no delay related to replication, as there is no replication!!

这篇关于BigQuery在其他地区之间存在区域限制或延迟？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！