Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements. See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License. You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
JOB_EXECUTION_LOG.TABLE.CREATE = CREATE TABLE \
IF NOT EXISTS JOB_EXECUTION_LOG ( \
auto_id int NOT NULL AUTO_INCREMENT, \
id VARCHAR (40) NOT NULL, \
job_name VARCHAR (100) NOT NULL, \
task_id VARCHAR (255) NOT NULL, \
hostname VARCHAR (255) NOT NULL, \
ip VARCHAR (50) NOT NULL, \
sharding_item INT NOT NULL, \
execution_source VARCHAR (20) NOT NULL, \
failure_cause VARCHAR (4000) NULL, \
is_success INT NOT NULL, \
start_time TIMESTAMP NULL, \
complete_time TIMESTAMP NULL, \
PRIMARY KEY (auto_id), \
UNIQUE KEY `id` (`id`) \
) ENGINE=InnoDB
JOB_EXECUTION_LOG.INSERT=INSERT INTO JOB_EXECUTION_LOG (id, job_name, task_id, hostname, ip, sharding_item, execution_source, is_success, start_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
JOB_EXECUTION_LOG.INSERT_COMPLETE=INSERT INTO JOB_EXECUTION_LOG (id, job_name, task_id, hostname, ip, sharding_item, execution_source, is_success, start_time, complete_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
JOB_EXECUTION_LOG.INSERT_FAILURE=INSERT INTO JOB_EXECUTION_LOG (id, job_name, task_id, hostname, ip, sharding_item, execution_source, failure_cause, is_success, start_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
JOB_EXECUTION_LOG.UPDATE=UPDATE JOB_EXECUTION_LOG SET is_success = ?, complete_time = ? WHERE id = ?
JOB_EXECUTION_LOG.UPDATE_FAILURE=UPDATE JOB_EXECUTION_LOG SET is_success = ?, complete_time = ?, failure_cause = ? WHERE id = ?
JOB_STATUS_TRACE_LOG.TABLE.CREATE= CREATE TABLE \
IF NOT EXISTS JOB_STATUS_TRACE_LOG ( \
auto_id int NOT NULL AUTO_INCREMENT, \
id VARCHAR (40) NOT NULL, \
job_name VARCHAR (100) NOT NULL, \
original_task_id VARCHAR (255) NOT NULL, \
task_id VARCHAR (255) NOT NULL, \
slave_id VARCHAR (50) NOT NULL, \
source VARCHAR (50) NOT NULL, \
execution_type VARCHAR (20) NOT NULL, \
sharding_item VARCHAR (100) NOT NULL, \
state VARCHAR (20) NOT NULL, \
message VARCHAR (4000) NULL, \
creation_time TIMESTAMP NULL, \
PRIMARY KEY (auto_id) \
) ENGINE=InnoDB
TASK_ID_STATE_INDEX.INDEX.CREATE=CREATE INDEX TASK_ID_STATE_INDEX ON JOB_STATUS_TRACE_LOG (task_id(128), state)
JOB_STATUS_TRACE_LOG.INSERT=INSERT INTO JOB_STATUS_TRACE_LOG (id, job_name, original_task_id, task_id, slave_id, source, execution_type, sharding_item, state, message, creation_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
JOB_STATUS_TRACE_LOG.SELECT=SELECT id, job_name, original_task_id, task_id, slave_id, source, execution_type, sharding_item, state, message, creation_time FROM JOB_STATUS_TRACE_LOG WHERE task_id = ?
JOB_STATUS_TRACE_LOG.SELECT_ORIGINAL_TASK_ID=SELECT original_task_id FROM JOB_STATUS_TRACE_LOG WHERE task_id = ? and state= 'TASK_STAGING' LIMIT 1
