BIgQuery响应非常缓慢 [英] BIgQuery Response are very slow

问题描述

在过去的7个小时里，我所有的查询查询都会花费比
更多的时间，通常应该花费几分钟的时间。

任何人都可以知道这可能是什么原因造成的？

解决方案

目前存在一个问题，即随机查询（JOIN EACH和GROUP EACH）卡住了。这在上周发生过几次，今天早上发生过一次。查询应该现在不被卡住。这是bigquery团队的优先级0问题。 如果您看到的查询花费的时间比预期的要长得多，请随意升级到您的支持代表或ping stackoverflow（尽管有时候关于生产问题的stackoverflow问题会得到低估，至少他们会被bigquery工程师阅读）。

In the last 7 hours, all my bigquery queries responses are taking more than hour,what usually should take few minutes.

Is anyone can know what can cause to this?

解决方案

There is currently an issue where shuffle queries (JOIN EACH and GROUP EACH) get stuck. This happened a couple of times last week, and once this morning. The queries should be un-stuck now. This is a priority-0 issue for the bigquery team.

If you see queries taking much longer than expected, please feel free to escalate to your support rep or ping stackoverflow (although sometimes stackoverflow questions about production issues get downvoted, at least they'll get read by the bigquery engineers).

这篇关于BIgQuery响应非常缓慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！