spqr icon indicating copy to clipboard operation
spqr copied to clipboard

Hashed-based approach sharding key type

Open Denchick opened this issue 1 year ago • 0 comments

There is no "HASH" keyword in the "ALTER DISTRIBUTION" command definition. Therefore, when using a key-range-based approach, we use the int64 golang type, but when using a hash-based approach, the underlying type becomes uint32, which leads to confusion.

What should we do?

  • Update or documentation
  • Introduce new uint type (should be the underlying type uint32 or uint64?)
  • Forbid using int type for hash-based approach

Denchick avatar Nov 22 '24 13:11 Denchick