rajagopr commented on code in PR #15257: URL: https://github.com/apache/pinot/pull/15257#discussion_r1994344588
########## pinot-controller/src/main/java/org/apache/pinot/controller/helix/core/retention/RetentionManager.java: ########## @@ -165,6 +183,85 @@ private void manageRetentionForRealtimeTable(String realtimeTableName, Retention } } + @VisibleForTesting + void manageRetentionForHybridTable(TableConfig realtimeTableConfig) { + List<String> segmentsToDelete = new ArrayList<>(); + String realtimeTableName = realtimeTableConfig.getTableName(); + String rawTableName = TableNameBuilder.extractRawTableName(realtimeTableName); + String offlineTableName = TableNameBuilder.OFFLINE.tableNameWithType(rawTableName); + try { + TableConfig offlineTableConfig = _pinotHelixResourceManager.getOfflineTableConfig(offlineTableName); + ZkHelixPropertyStore<ZNRecord> propertyStore = _pinotHelixResourceManager.getPropertyStore(); + Schema schema = ZKMetadataProvider.getTableSchema(propertyStore, offlineTableName); + if (schema == null) { + throw new RuntimeException("Failed to get schema for table: " + offlineTableName); + } + String timeColumn = null; + SegmentsValidationAndRetentionConfig validationConfig = offlineTableConfig.getValidationConfig(); + if (validationConfig != null) { + timeColumn = validationConfig.getTimeColumnName(); + } + if (StringUtils.isEmpty(timeColumn)) { + throw new RuntimeException("TimeColumn is null or empty for table: " + offlineTableName); + } + DateTimeFieldSpec dateTimeSpec = schema.getSpecForTimeColumn(timeColumn); + if (dateTimeSpec == null) { + throw new RuntimeException(String.format("Failed to get DateTimeFieldSpec for time column: %s of table: %s", + timeColumn, offlineTableName)); + } + DateTimeFormatSpec timeFormatSpec = dateTimeSpec.getFormatSpec(); + if (timeFormatSpec.getColumnUnit() == null) { + throw new RuntimeException(String.format("Time unit must be configured in the field spec for time column: %s of" + + " table: %s", timeColumn, offlineTableName)); + } + // For HOURLY table with time unit other than DAYS, use (maxEndTime - 1 HOUR) as the time boundary; otherwise, use + // (maxEndTime - 1 DAY) + boolean isHourlyTable = CommonConstants.Table.PUSH_FREQUENCY_HOURLY.equalsIgnoreCase( + IngestionConfigUtils.getBatchSegmentIngestionFrequency(realtimeTableConfig)) + && timeFormatSpec.getColumnUnit() != TimeUnit.DAYS; + long timeOffsetMs = isHourlyTable ? TimeUnit.HOURS.toMillis(1) : TimeUnit.DAYS.toMillis(1); + long offlineSegmentsMaxEndTimeMs = -1; + // Determine the max end time of all offline segments + for (SegmentZKMetadata segmentZKMetadata : _pinotHelixResourceManager.getSegmentsZKMetadata(offlineTableName)) { + // skip empty segments + if (segmentZKMetadata.getTotalDocs() == 0) { + LOGGER.warn("Skipping empty segment: {} from table: {}", segmentZKMetadata.getSegmentName(), + offlineTableName); + continue; + } + offlineSegmentsMaxEndTimeMs = Math.max(offlineSegmentsMaxEndTimeMs, segmentZKMetadata.getEndTimeMs()); + } + + if (offlineSegmentsMaxEndTimeMs == -1) { + throw new RuntimeException("Failed to determine max end time of segments for table: " + offlineTableName); + } + + // realtime table segments older than the time boundary will be deleted + long timeBoundaryMs = offlineSegmentsMaxEndTimeMs - timeOffsetMs; + + // Iterate over all COMPLETED segments of the REALTIME table and check if they are eligible for deletion. + for (SegmentZKMetadata segmentZKMetadata : _pinotHelixResourceManager.getSegmentsZKMetadata(realtimeTableName)) { + // The segment should be in COMPLETED state + if (segmentZKMetadata.getStatus() == CommonConstants.Segment.Realtime.Status.IN_PROGRESS + || segmentZKMetadata.getStatus() == CommonConstants.Segment.Realtime.Status.COMMITTING) { + continue; + } + // The segment should be older than the cutoff time + if (segmentZKMetadata.getEndTimeMs() < timeBoundaryMs) { + segmentsToDelete.add(segmentZKMetadata.getSegmentName()); + } + } + if (!segmentsToDelete.isEmpty()) { Review Comment: Done. -- 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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org