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
{count} votes

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 17,866 Reputation points Microsoft Employee
    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