-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/65385/
-----------------------------------------------------------
(Updated Feb. 6, 2018, 1 a.m.)
Review request for oozie.
Changes
-------
verify indexes - create, upgrade db
Repository: oozie-git
Description
-------
Add indices to speed up SELECT operations.
Index user_name column
for purge service OOZIE-1803:
CREATE INDEX "OOZIEDB"."BUNDLE_JOBS_END_TIME_IDX" ON "BUNDLE_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."COORD_JOBS_END_TIME_IDX" ON "COORD_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."WF_JOBS_END_TIME_IDX" ON "WF_JOBS" ("END_TIME");
CREATE INDEX "OOZIEDB"."COORD_ACTIONS_JOB_ID_IDX" ON "COORD_ACTIONS" ("JOB_ID");
CREATE INDEX "OOZIEDB"."COORD_JOBS_BUNDLE_ID_IDX" ON "COORD_JOBS" ("BUNDLE_ID");
CREATE INDEX "OOZIEDB"."WF_ACTIONS_WF_ID_IDX" ON "WF_ACTIONS" ("WF_ID");
CREATE INDEX "OOZIEDB"."WF_JOBS_PARENT_ID_IDX" ON "WF_JOBS" ("PARENT_ID");
CREATE INDEX "OOZIEDB"."BUNDLE_ACTIONS_BUNDLE_ID_IDX" ON "BUNDLE_ACTIONS"
("BUNDLE_ID");
Composite indices to speed up operations on the web UI
Diffs (updated)
-----
tools/src/main/java/org/apache/oozie/tools/OozieDBCLI.java
4bb6dd8606784fc0c4eb7aaedef79c59617f65eb
Diff: https://reviews.apache.org/r/65385/diff/5/
Changes: https://reviews.apache.org/r/65385/diff/4-5/
Testing
-------
Thanks,
Attila Sasvari
