The following query shows which AMPs contain the rows of a table.
sel col1, hashamp(hashbucket(hashrow(col1))
map = map1count3 colocate using u1_tabm1c3)
(named "which amp?")
from u1.tabm1c3 order by 1;
col1 which amp?
----------- -----------
0 3
1 2
2 3
3 2
4 2
5 2
6 3
7 2
8 3
9 1