Share via

Does alter_distributed_table for distribution key require downtime? Or this can be done on the fly?

Sahu, Rahul 1 Reputation point
2022-05-06T07:46:59.35+00:00

Does alter_distributed_table for distribution key require downtime? Or this can be done on the fly?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 20,936 Reputation points Microsoft Employee Moderator
    2022-05-13T15:51:12.44+00:00

    Hi anonymous user Thank you for clarifying the question.

    My understanding is that you are asking if re-sharding of data across the shards will require downtime. Please let me know if my understanding is not correct.
    Hyperscale (Citus) offers zero-downtime rebalancing, meaning queries can run without interruption during shard rebalancing.

    Regards,
    Oury

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.