[ https://issues.apache.org/jira/browse/GOBBLIN-2137?focusedWorklogId=931016&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-931016 ]
ASF GitHub Bot logged work on GOBBLIN-2137: ------------------------------------------- Author: ASF GitHub Bot Created on: 20/Aug/24 18:51 Start Date: 20/Aug/24 18:51 Worklog Time Spent: 10m Work Description: arjun4084346 commented on code in PR #4032: URL: https://github.com/apache/gobblin/pull/4032#discussion_r1723809957 ########## gobblin-service/src/main/java/org/apache/gobblin/service/modules/orchestration/MysqlDagStateStoreWithDagNodes.java: ########## @@ -77,20 +77,18 @@ public class MysqlDagStateStoreWithDagNodes implements DagStateStoreWithDagNodes protected final GsonSerDe<List<JobExecutionPlan>> serDe; private final JobExecutionPlanDagFactory jobExecPlanDagFactory; - // todo add a column that tells if it is a running dag or a failed dag protected static final String CREATE_TABLE_STATEMENT = "CREATE TABLE IF NOT EXISTS %s (" - + "dag_node_id VARCHAR(" + ServiceConfigKeys.MAX_DAG_NODE_ID_LENGTH + ") CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, " - + "parent_dag_id VARCHAR(" + ServiceConfigKeys.MAX_DAG_ID_LENGTH + ") NOT NULL, " - + "dag_node JSON NOT NULL, " + + "dag_node_id VARCHAR(" + ServiceConfigKeys.MAX_DAG_NODE_ID_LENGTH + + ") CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, " + "parent_dag_id VARCHAR(" + + ServiceConfigKeys.MAX_DAG_ID_LENGTH + ") NOT NULL, " + "dag_node JSON NOT NULL, " + "modified_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, " - + "PRIMARY KEY (dag_node_id), " - + "UNIQUE INDEX dag_node_index (dag_node_id), " - + "INDEX dag_index (parent_dag_id))"; - - protected static final String INSERT_STATEMENT = "INSERT INTO %s (dag_node_id, parent_dag_id, dag_node) " - + "VALUES (?, ?, ?) AS new ON DUPLICATE KEY UPDATE dag_node = new.dag_node"; - protected static final String GET_DAG_NODES_STATEMENT = "SELECT dag_node FROM %s WHERE parent_dag_id = ?"; - protected static final String GET_DAG_NODE_STATEMENT = "SELECT dag_node FROM %s WHERE dag_node_id = ?"; + + "is_failed_dag INT NOT NULL DEFAULT 0, " + "PRIMARY KEY (dag_node_id), " Review Comment: is_failed_dag TINYINT(1) DEFAULT 0 or is_failed_dag BOOLEAN DEFAULT FALSE Issue Time Tracking ------------------- Worklog Id: (was: 931016) Time Spent: 0.5h (was: 20m) > Merge Failed Node Dag State Store and Dag Node State Store > ---------------------------------------------------------- > > Key: GOBBLIN-2137 > URL: https://issues.apache.org/jira/browse/GOBBLIN-2137 > Project: Apache Gobblin > Issue Type: Improvement > Reporter: Aditya Pratap Singh > Priority: Minor > Time Spent: 0.5h > Remaining Estimate: 0h > > Merge Failed Node Dag State Store and Dag Node State Store -- This message was sent by Atlassian Jira (v8.20.10#820010)