Skip to content

PRAGMA TablePathPrefix for ALTER TOPIC #4089

@apervushin

Description

@apervushin

Hi,

We use some kind of migration manager to apply DDL migrations to YDB. And we've faced with an issue during the following migration:

PRAGMA TablePathPrefix = '/database/path/to/tables';

ALTER TABLE `my_table` ADD CHANGEFEED `my_feed` WITH (
    FORMAT = 'JSON',
    MODE = 'UPDATES',
    RETENTION_PERIOD = Interval("P7D")
);

ALTER TOPIC `my_table/my_feed` ADD CONSUMER `my_consumer`;

ALTER TOPIC migration fails due to TablePathPrefix does not work for this command (only for ALTER TABLE). As a result we created:

  • /database/path/to/tables/my_table - table
  • /database/path/to/tables/my_table/my_feed - topic

But ALTER TOPIC trying to find /database/my_table/my_feed instead of /database/path/to/tables/my_table/my_feed.

Is it possible to make PRAGMA TablePathPrefix affect ALTER TOPIC as well or add something like PRAGMA TopicPathPrefix?

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions