Goal: provide an easy/intuitive way to schedule repetitive queries directly via the Editor.
- Schedule a new query
- Update a schedule
- List scheduled queries
- Hive 4
- Apache Oozie
- Celery Beat
- Apache Airflow
Currently work in progress with focus on Hive 4 and Celery Beat.
About Apache Hive scheduling:
create scheduled query Q1 executed as joe scheduled '1 1 * * *’ as update t set a=1;
* change schedule
alter scheduled query Q1 cron '2 2 * * *'
* change query
alter scheduled query Q1 defined as select 2
alter scheduled query Q1 set disabled
alter scheduled query Q1 set enabled
* list status
select * from sysdb.scheduled_queries;
drop scheduled query Q1