Two billion record limit for non-partitioned HANA tables?

[john_hawk]

Is there a two billion record limit for non-partitioned HANA tables? I've seen discussion on SCN, but can't find any official SAP documentation.

[Former Member · Accepted solution]

Hi John,

Yes there is a limit for non-partitioned tables in HANA. In the first page of this document says:

A non - partitioned table cannot store more than 2 billion rows. By using partitioning, this

limit may overcome by distributing the rows to several partitions. Please note, each partition must not contain more than 2 billion rows.

Cheers,

Sarhan.