Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PRAGMA TablePathPrefix for ALTER TOPIC #4089

Closed
apervushin opened this issue Apr 24, 2024 · 0 comments · Fixed by #4741 or #4866
Closed

PRAGMA TablePathPrefix for ALTER TOPIC #4089

apervushin opened this issue Apr 24, 2024 · 0 comments · Fixed by #4741 or #4866
Assignees
Labels
bug Something isn't working

Comments

@apervushin
Copy link

apervushin commented Apr 24, 2024

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?

@va-kuznecov va-kuznecov added the bug Something isn't working label May 17, 2024
@Tony-Romanov Tony-Romanov self-assigned this May 21, 2024
@Tony-Romanov Tony-Romanov linked a pull request May 22, 2024 that will close this issue
@Tony-Romanov Tony-Romanov linked a pull request May 27, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
3 participants