You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create policy p1 primary_region='r1' regions='r1,r2';
createtablet (id int) placement policy p1;
droptable t;
droptable p1;
-- or create a new policy with a same name p1 here
recover table t;
show create table t; -- should t still referring a policy p1 ?
Maybe there are two solutions:
recover all table's placement as direct options. For example, show create table t will return the result as:
Fails if meta not match. It will check if the policy with the same ID exists when recovering, if not, it fails. Notice that we can set sys variable placement_checks to false to skip checking. At this time if the policy p1 does not exists (or with a different id) , it will recover a table without any placement settings.
The text was updated successfully, but these errors were encountered:
i.e. In the case of drop table t; drop placement policy p1; create placement policy p1 ..; recover table t I do not think it is correct to refer to the original policy p1.
We should handle the below scene:
Maybe there are two solutions:
show create table t
will return the result as:placement_checks
tofalse
to skip checking. At this time if the policy p1 does not exists (or with a different id) , it will recover a table without any placement settings.The text was updated successfully, but these errors were encountered: