3361169 - Table distribution/redistribution not creating the desired/expected reorg plan in SAP HANA

Prerequisites

• You are familiar with the SAP HANA table distribution topic (See Also section). You know the process well, probably you had already done SAP HANA table distribution / redistribution in the past.

Improper partitioning setup

• You must not generate a reorg plan for a table. Several tables of a table group must always be handled together. (SAP Note: 2019973, 2374652)
• Actual partitioning of the tables in the same group has to be the same.

Observations

• You want to execute SAP HANA table redistribution because the record count increased in one of the table in the group and the table redistribution is necessary.
• You already checked the biggest table (record count) in the group, e.g. with SQL Statement collection report called "HANA_Tables_DataCollector" (SAP Note 1969700) or in SAP HANA Studio (SAP Knowledge Base Article 3288401) or in SQL Editor with SELECT statement,
  SQL command: SELECT count(*) FROM '%<TABLE_NAME>%';
• Incorrect results/details in reorg plan.
  SQL command: SELECT * FROM reorg_plan;
  Known scenarios:
  
  • You followed the process and realized OLD_PARTITION_SPEC column is not accurate in all the group tables. This can happen when the actual partitioning of the tables in the same group is different (this is not the SAP recommendation).
  • You followed the process and realized, table distribution not creating the desired/expected reorg plan (NEW_PARTITION_SPEC). When you checked the reorg plan you expected to see increased number of partitions but instead you saw reduced number of partitions.
• Reorg plan was not executed because it make no sense to run it. In case of run it, there is a good chance that it will run into an error.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP HANA, platform edition 2.0

partition, partitioning, partitioned, table, SAP, HANA, BW, database, DB, table, distribution, redistribution, re-distribution, CALL REORG_GENERATE, CALL REORG_EXECUTE, IS_GROUP_LEAD, GROUP, LEAD, flag, OLD_PARTITION_SPEC, NEW_PARTITION_SPEC, reorg_plan , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , Problem