[ Question : Hash Bucketing - Tablet Pruning ] Hi...
# questions-and-troubleshooting
a
[ Question : Hash Bucketing - Tablet Pruning ] Hi, All! In Hash Bucketing, does bucket pruning only work when the
WHERE
clause filters all columns used in the bucketing expression? For example, if the table is bucketed by
HASH(A, B)
, will bucket pruning occur only when the
WHERE
clause filters on both A and B
? 🤔 Thanks for answering in advance!
k
yes, can't calculate the hash bucket when only single A or single B provided.
👍 2
a
oh, thanks ! 🙂