Table distribution and partition in SAP HANA

[Former Member]

Hi All,

Have some queries regarding table distribution and partitioning.

Few things like for table redistribution, is there a way to run it via sql or a script. Since we dont want to go through the graphical interface from HANA studio. We see unequal distrubution of memory across the nodes. We feel that definitely there is a need for table restribution across the nodes.

So we wanted to know if people have tried generating plan manually and then executed the plan manually.

[Former Member]

Few more inputs from my side.

select  * from "_SYS_RT"."TABLE_PLACEMENT"

sap.bw.cube  40,000,000 3 40,000,000 slave

sap.bw.aggr  40,000,000 3 40,000,000 slave

sap.bw.dso  40,000,000 3 40,000,000 slave

sap.bw.iobj  0 3 0 slave

sap.bw.psa  2,000,000,000 1 2,000,000,000 slave

sap.bw.dtp  2,000,000,000 1 2,000,000,000 slave

sap.bw.temp  0 3 0 slave

sap.bw.trex  0 3 0 slave

sap.bw.openhub  0 3 0 slave

BW_CUBE  40,000,000 3 40,000,000 slave

BW_AGGR  40,000,000 3 40,000,000 slave

BW_DSO  40,000,000 3 40,000,000 slave

BW_IOBJ  0 3 0 slave

BW_PSA  2,000,000,000 1 2,000,000,000 slave

BW_DTP  2,000,000,000 1 2,000,000,000 slave

BW_TEMP  0 3 0 slave

BW_OPENHUB  0 3 0 slave

These are the present rules which we see. But the memory usage is not the same across the nodes. If the difference is small then it can be ignored. But the difference is quite large.