SAP Knowledge Base Article - Preview

3734541 - Partitioning guidance for HANA column store table/partition reached 2 billion and impact to Migration

Symptom

  • In the HANA database, a column store table or partition exceeded 2,000,000,000 rows.
  • Error when the limit is exceeded: '2055: SQL message: maximum number of rows per table or partition reached: '
  • You want to know whether the 2 billion limit can be changed.
  • Whether pre-partitioning activities will impact the follow-up system migration.


Read more...

Environment

  • SAP HANA Database 1.0
  • SAP HANA Database 2.0

Keywords

HANA, column store, 2 billion rows, row limit, maximum number of rows per table or partition, 2055, migration, system migration,  sql message 2055, partitioning, table partition, pre-partitioning, migration impact, system copy, data archiving, data housekeeping, hana table limit , 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.