English 中文(简体)
排定的盘问习惯时间
原标题:Big query scheduled query custom timing

I need to schedule a query on BigQuery form Monday to Saturday, every 15 minutes from 04:00 to 21:00. That s my try:

every mon, tue, wed, thu, fri, sat every 15 minutes from 04:00 to 21:00

我确信,这一部分“从4时至2时1分15分钟”正在发挥作用,需要增加与一周日有关的部分。

问题回答

EDIT: read set_up_scheduled_queries

时间安排的重要考虑:

1.You must decide if you want to use either a sub-daily interval or a custom interval. You cannot mix and use elements from the various interval types. The following is an example of an invalid schedule definition: schedule: every 6 hours mon,wed,fri

2.Only a single instance of a job should run at any time. The Cron service is designed to provide "at least once" delivery; that is, if a job is scheduled, App Engine sends the job request at least one time. In some rare circumstances, it is possible for multiple instances of the same job to be requested, therefore, your request handler should be idempotent, and your code should ensure that there are no harmful side-effects if this occurs.

based on the above you have two option

页: 1

www.un.org/chinese/sc/presidency.asp

每周七天

页: 1

如果当时尝试,则无法确定间隔时间。

每天一次

你也说过:

<代码>每15分钟,从0到2时至2时

因此,





相关问题
Bigquery table join with specific conditions

I have this table A which contains | ID | Start Date | End Date | |:---- |:----------:| --------:| | 1 | 2020-03-01 |2020-03-02| | | 2020-05-01|2020-05-02| | 2 | 2020-06-01|2020-06-02| ...

SQL IN operator in Bigquery

Suppose I have two tables of devices, my table 1 and table 2. I need to get all the models that has band (in table). Looking for ways on to execute this in sql bigquery. Thanks for the answer Table 2 ...

页: 1

I am trying to split my Date column into 2 separate columns (DATE & TIME). Currently, the date column has the date with a time stamp, and I need to drop the time stamp or put it into another ...

Does Google BigQuery require a schema? [closed]

I want to use bigquery for storing logs. Does it require a fixed schema like Mysql and other RDBMS or it is like nosql where there is no schema?

How to Analyze and Query big chunks of data

I need to: 1. Analyze big files of http logs I m thinking in using mapreduce but I m not sure where to host it. Shall I use App Engine Mapper or EC2+MapReduce or simply use it in my VPS? Other ...

MapReduce in the cloud

Except for Amazon MapReduce, what other options do I have to process a large amount of data?

热门标签