Kamil Bregula created AIRFLOW-6242:
--------------------------------------

             Summary: Introduce run_type in DAG Run table
                 Key: AIRFLOW-6242
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-6242
             Project: Apache Airflow
          Issue Type: Bug
          Components: backfill, scheduler
    Affects Versions: 1.10.6
            Reporter: Kamil Bregula


Hello,

Before you start reading this ticket, I want to tell you one thing - you are 
wonderful. 

We use queries that use like expressions to filter two types of DAG Run.
 * Backfill:
 
[https://github.com/apache/airflow/blob/699aea8ee368abcba29d717daf2580f897ab9d93/airflow/jobs/backfill_job.py#L52]
 * Scheduled
 
[https://github.com/apache/airflow/blob/699aea8ee368abcba29d717daf2580f897ab9d93/airflow/models/dagrun.py#L46]

This type of expression can affect performance and it seems a better idea to 
store this information in a separate column. This may allow a query planner to 
create a better query plan in the database engine. 

Thanks for reading this ticket.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to