aryangupta1998 commented on code in PR #8409:
URL: https://github.com/apache/ozone/pull/8409#discussion_r2077653494
##########
hadoop-ozone/tools/src/main/java/org/apache/hadoop/ozone/debug/logs/container/utils/SQLDBConstants.java:
##########
@@ -68,6 +68,10 @@ public final class SQLDBConstants {
"WHERE d.container_id = ? ORDER BY d.datanode_id ASC, d.timestamp ASC;";
public static final String CREATE_DCL_CONTAINER_STATE_TIME_INDEX = "CREATE
INDEX IF NOT EXISTS " +
"idx_dcl_container_state_time ON DatanodeContainerLogTable(container_id,
container_state, timestamp);";
+ public static final String CREATE_CONTAINER_ID_INDEX = "CREATE INDEX IF NOT
EXISTS idx_containerlog_container_id " +
+ "ON ContainerLogTable(container_id);";
+ public static final String SELECT_DISTINCT_CONTAINER_IDS_QUERY =
+ "SELECT DISTINCT container_id FROM ContainerLogTable";
Review Comment:
Right!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@ozone.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@ozone.apache.org
For additional commands, e-mail: issues-h...@ozone.apache.org
