每次我在解释选项卡中的Google BigQuery中执行查询时,我都会看到它们涉及平均等待时间。是否有可能知道等待时间的百分比或秒数?
解决方案
由于BigQuery是一项托管服务,因此很多客户都在使用它。它具有基于billingTier的内部日程安排系统(这里解释 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 cloud.google/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.
更多推荐
大查询执行查询之前的等待时间是多少?
发布评论