manticoresearch icon indicating copy to clipboard operation
manticoresearch copied to clipboard

Request: option to include 'CREATE TABLE' in output of `indexer --print-rt`

Open barryhunter opened this issue 3 years ago • 0 comments

Is your feature request related to a problem? Please describe.

Considering using the new manticore helm chart - which is a using the new 'datadir' mode (becauase it works with replication)

... have a whole bunch of 'plain' indexes from legacy system need to convert to new format. Will generally mean issuing the right CREATE TABLE

Describe the solution you'd like

Would be nice to have indexer able to create the RT table definition in the new CREATE TABLE syntax. Based on the plain index config.

Then could in theory take the output of indexer --print-rt plain newrt --include-create-rt on the old config, and run it directly into the new 'cluster'
(then running ALTER CLUSTER ... ADD .. )

Describe alternatives you've considered

Well of course we can construct the CREATE TABLE ourselves (either from from the comments of the output, or direct form index, (maybe DESCRIBE etc) ) - or seems like would be able to use the new SHOW CREATE TABLE command, but doesnt seem to work on plain indexes.

barryhunter avatar May 19 '21 12:05 barryhunter