大查询执行查询之前的等待时间是多少？ [英] What will be the wait time before big query executes a query?

问题描述

每次我在解释选项卡中的Google BigQuery中执行查询时，我都会看到它们涉及平均等待时间。是否有可能知道等待时间的百分比或秒数？

解决方案

由于BigQuery是一项托管服务，因此很多客户都在使用它。它具有基于billingTier的内部日程安排系统（这里解释 https://cloud.google。 com / bigquery / pricing＃high-compute ）和其他内部项目。基于此，查询计划根据群集可用性执行。因此，最短的时间才能找到一组机器来执行你的工作。

我从来没有见过那么重要的时刻。如果您遇到此问题，请联系Google支持以查看您的项目。如果您编辑原始问题并添加工作ID，则谷歌工程师可能会检查出是否存在问题。

Every time I execute a query in Google bigquery in the Explanation tab, I can see that their involves an average waiting time. Is it possible to know the percentage or seconds of wait time?

解决方案

Since BigQuery is a managed service, around the glob a lot of customers are using it. It has an internal scheduling system based on the billingTier (explained here https://cloud.google.com/bigquery/pricing#high-compute) and other internals of your project. Based on this the query is scheduled to be executed based on the cluster availability. So there will be a minimum time until it finds a cluster of machines to execute your job.

I never seen there significant times. In case you have this issue then contact google support to see your project. If you edit your original question and add a job ID, a google enginner may check it out if there is an issue orn ot.

这篇关于大查询执行查询之前的等待时间是多少？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！