SAP Knowledge Base Article - Preview

3167108 - After running table distribution, the table is not partitioned - SAP BW on SAP HANA

Symptom

You want to perform table distribution/redistribution (e.g., because of partitioning a table), but the table is not partitioned.

Command (structure):

    CALL REORG_GENERATE(<algorithm integer>, <optional parameter string>);
    CALL REORG_EXECUTE(<plan_id>)

Example command:

    CALL REORG_GENERATE(6,'GROUP_NAME=>TABLEGROUP_NAME1');
    CALL REORG_EXECUTE(?);

The steps completed successfully but the table is not partitioned.

    select * from m_cs_tables where table_name = ' TABLE_NAME1' - - > not partitioned PART_ID = 0


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

partition, partitioning, partitioned, table, SAP HANA, saphana, SAP BW on SAP HANA, database, DB, table distribution, table redistribution, table 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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.