SAP Knowledge Base Article - Public

3344846 - Local tables reaching 2 billion rows limit in SAP Datasphere

Symptom

Local Tables reaching 2 billion rows limit.

Environment

SAP Datasphere

Reproducing the Issue

When getting closer to the 2 billion rows limit in a local table, partitioning is an option to overcome that.

Cause

Feature Request

Resolution

SAP Datasphere now offers partitioning for local tables, according to the SAP Help link.

See Also

SAP Datasphere Roadmap

Keywords

limitation, rows, 2bi, 2billion, partitioning, HANA, local table, persisted view, General error, 2055, maximum number of rows per table or partition reached, insufficient privilege, alter table, partition by hash, partitions , KBA , DS-SM , Space Management , XX-SER-MCC , Mission Control Center - Knowledge Management , Product Enhancement

Product

SAP Datasphere all versions