On Wed, Oct 24, 2018 at 11:23 PM Amit Langote <amitlangote09@gmail.com> wrote:
> On Wed, Oct 24, 2018 at 8:09 PM 张心灵 <zhangsilly@gmail.com> wrote:
> > BTW: SELECT 14211 % 128 was 3, why record of HASH column user_id 14211 data in partition of 114?
>
> Hash partitioning doesn't apply modulus 3 directly to the value
> '14211'. It first computes its hash using the hashing function for
> bigint type and then applies the modulus.
Oops, I meant to say "doesn't apply modulus 128 directly to the value 14211".
Thanks,
Amit