Don't list old metric names? about graphite-clickhouse HOT 5 OPEN

It looks related to #64

from graphite-clickhouse.

@mzealey : if your Clickhouse support deletion you can try same trick, but with DELETE

ALTER TABLE graphite_index DELETE 
WHERE (Path LIKE 'PREFIX.%')
GROUP BY Path
HAVING max(Version) < toUInt32(toDateTime(today() - 7))

But I'm not sure if DELETE WHERE supports GROUP BY ... HAVING clause.

from graphite-clickhouse.

I imagine sometihng like this would work:

ALTER TABLE graphite_index
DELETE WHERE Path in (
  SELECT Path
  FROM graphite_index
  WHERE (Path LIKE 'PREFIX.%')
  GROUP BY Path
  HAVING max(Version) < toUInt32(toDateTime(today() - 7))
)

But there are also partial and reversed paths etc as well; do they not need deleting somehow?

from graphite-clickhouse.

Yep, then SELECT should bit more complex. Reversed is easy, not sure about partial, though.

from graphite-clickhouse.

Also I think you want to select the Paths from graphite_index first, then remove the data from the graphite table and then tidy the graphite_index table? Does that make sense?

from graphite-clickhouse.