in contrib/ambari-log4j/src/main/java/org/apache/ambari/log4j/hadoop/mapreduce/jobhistory/MapReduceJobHistoryUpdater.java [373:484]
private void initializeTaskAttemptPreparedStatements() throws SQLException {
/**
* TaskAttempt events
*/
// TaskAttemptStartedEvent
PreparedStatement taskAttemptStartedPrepStmnt =
connection.prepareStatement(
"INSERT INTO " +
TASKATTEMPT_TABLE +
" (" +
"jobId, " +
"taskId, " +
"taskType, " +
"startTime, " +
"taskTracker, " +
"locality, " +
"avataar, " +
"taskAttemptId" +
") " +
"VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
);
entitySqlMap.put(
TaskAttemptStartedEvent.class, taskAttemptStartedPrepStmnt);
// TaskAttemptFinishedEvent
PreparedStatement taskAttemptFinishedPrepStmnt =
connection.prepareStatement(
"UPDATE " +
TASKATTEMPT_TABLE +
" SET " +
"jobId = ?, " +
"taskId = ?, " +
"taskType = ?, " +
"finishTime = ?, " +
"status = ?, " +
"taskTracker = ? " +
" WHERE " +
"taskAttemptId = ?"
);
entitySqlMap.put(
TaskAttemptFinishedEvent.class, taskAttemptFinishedPrepStmnt);
// TaskAttemptUnsuccessfulEvent
PreparedStatement taskAttemptUnsuccessfulPrepStmnt =
connection.prepareStatement(
"UPDATE " +
TASKATTEMPT_TABLE +
" SET " +
"jobId = ?, " +
"taskId = ?, " +
"taskType = ?, " +
"finishTime = ?, " +
"status = ?, " +
"taskTracker = ?, " +
"error = ? " +
" WHERE " +
"taskAttemptId = ?"
);
entitySqlMap.put(
TaskAttemptUnsuccessfulCompletionEvent.class,
taskAttemptUnsuccessfulPrepStmnt);
// MapAttemptFinishedEvent
PreparedStatement mapAttemptFinishedPrepStmnt =
connection.prepareStatement(
"UPDATE " +
TASKATTEMPT_TABLE +
" SET " +
"jobId = ?, " +
"taskId = ?, " +
"taskType = ?, " +
"mapFinishTime = ?, " +
"finishTime = ?, " +
"inputBytes = ?, " +
"outputBytes = ?, " +
"status = ?, " +
"taskTracker = ? " +
" WHERE " +
"taskAttemptId = ?"
);
entitySqlMap.put(
MapAttemptFinishedEvent.class, mapAttemptFinishedPrepStmnt);
// ReduceAttemptFinishedEvent
PreparedStatement reduceAttemptFinishedPrepStmnt =
connection.prepareStatement(
"UPDATE " +
TASKATTEMPT_TABLE +
" SET " +
"jobId = ?, " +
"taskId = ?, " +
"taskType = ?, " +
"shuffleFinishTime = ?, " +
"sortFinishTime = ?, " +
"finishTime = ?, " +
"inputBytes = ?, " +
"outputBytes = ?, " +
"status = ?, " +
"taskTracker = ? " +
" WHERE " +
"taskAttemptId = ?"
);
entitySqlMap.put(
ReduceAttemptFinishedEvent.class, reduceAttemptFinishedPrepStmnt);
}