When using Automatic Schema Generation, is it poss...
# general
n
When using Automatic Schema Generation, is it possible to define the defaults. For example, we noticed that tables are created with:
Copy code
WITH(
  'comment' = 'Created on insertion',
  merge_mode = 'last_non_null'
)
but in our use case:
Copy code
WITH(
  append_mode = 'true',
  sst_format = 'flat'
);
Is more performant for us, and is almost always the right thing.
d
You can specify the HTTP header
x-greptime-hints: append_mode=true, sst_format=flat
to set the table options.
Sorry. the
sst_format
can’t be set in this way, I’ll create a PR to fix it. You have to alter the table after creation.