Date Iteration
Bash
Snippets
SQL Example:
macOSLinuxDB_NAME="journal"
TABLE_NAME="otel_logs"
START_DATE="2025-01-01"
END_DATE="2025-01-10"
current=$START_DATE
while [[ "$current" < "$END_DATE" || "$current" == "$END_DATE" ]]; do
echo "ALTER TABLE ${DB_NAME}.${TABLE_NAME} DROP PARTITION...