0

If I create table:

    │ CREATE TABLE default.graphite
(
    `Path` String,
    `Value` Float64,
    `Time` UInt32,
    `Date` Date,
    `Timestamp` UInt32
)
ENGINE = GraphiteMergeTree('graphite_rollup')
PARTITION BY toYYYYMM(Date)
ORDER BY (Path, Time)
SETTINGS index_granularity = 8192

I can: ALTER TABLE graphite MODIFY SETTING storage_policy = '???';

But if my table created:

│ CREATE TABLE graphite
(
    `Path` String,
    `Value` Float64,
    `Time` UInt32,
    `Date` Date,
    `Timestamp` UInt32
)
ENGINE = GraphiteMergeTree(Date, (Path, Time), 8192, 'graphite_rollup') │

I can't =( I recieve error: DB::Exception: Cannot alter settings, because table engine doesn't support settings changes.

Help me, how I can change settin?

└──────────────────────────────────────────────────────────────────────────

Andrew Kaa
  • 117
  • 9
  • 1
    As I understand it, I use deprecated method the table creation . And i need change it. But I don't know how yet. https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/graphitemergetree – Andrew Kaa Jul 22 '22 at 16:15
  • 2
    yes, tables with the depricated syntax does not support it. – Denny Crane Jul 22 '22 at 19:38
  • @DennyCrane is true, you must (re)define the table with a new syntax, actually, recreate it. Maybe this can help to do it: https://stackoverflow.com/questions/68716267/is-it-possible-to-change-a-table-engine-of-an-existed-clickhouse-table – gelin Sep 30 '22 at 10:44
  • @gelin it will not help. – Denny Crane Sep 30 '22 at 12:47

1 Answers1

0

It was decided to create a table with a new syntax and transfer data to it

Andrew Kaa
  • 117
  • 9