ERROR: Job table memory clean-up failed at Database query
by root
Failed to execute SQL:
WITH date_counts AS (
SELECT
CASE
WHEN end_time IS NULL THEN 'NULL'
WHEN end_time > CURRENT_DATE THEN 'Future'
ELSE DATE(end_time)::text
END as date_group,
COUNT(*) as count
FROM hpco_gdb.job_cluster_gpscc3
GROUP BY 1
)
SELECT date_group, count
FROM date_counts
ORDER BY
CASE
WHEN date_group = 'NULL' THEN '9999-12-31'::date
ELSE date_group::date
END DESC;
1 year, 2 months
ERROR: Job table memory clean-up failed at Database query
by root
Failed to execute SQL:
WITH date_counts AS (
SELECT
CASE
WHEN end_time IS NULL THEN 'NULL'
WHEN end_time > CURRENT_DATE THEN 'Future'
ELSE DATE(end_time)::text
END as date_group,
COUNT(*) as count
FROM hpco_gdb.job_cluster_gpsc8
GROUP BY 1
)
SELECT date_group, count
FROM date_counts
ORDER BY
CASE
WHEN date_group = 'NULL' THEN '9999-12-31'::date
ELSE date_group::date
END DESC;
1 year, 2 months
ERROR: Job table memory clean-up failed at Database query
by root
Failed to execute SQL:
WITH date_counts AS (
SELECT
CASE
WHEN end_time IS NULL THEN 'NULL'
WHEN end_time > CURRENT_DATE THEN 'Future'
ELSE DATE(end_time)::text
END as date_group,
COUNT(*) as count
FROM hpco_gdb.job_cluster_gpsc7
GROUP BY 1
)
SELECT date_group, count
FROM date_counts
ORDER BY
CASE
WHEN date_group = 'NULL' THEN '9999-12-31'::date
ELSE date_group::date
END DESC;
1 year, 2 months
