Two billion rows limit on hana table need expert advice

[Former Member]

I see there is a 2 billion rows table limit on hana, and need to do partitions on db table's.

Question: 2 billion rows of what? even if i have a table with two fields vs 250 fields is it by number of rows or the size of table with in the database?

Thanks a lot for the helpful info.

[hai_murali_here · Accepted solution]

Hi Kumar,

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.

Partitioning is typically used in distributed landscapes but only for column store tables. But it may also be beneficial for single-host systems.

Rgds,

Murali

[Former Member · Accepted solution]

Hello Murali,

What does it mean by distributed landscapes? a landscape with several systems within hana studio?

thanks,

Kumar.

[hai_murali_here · Accepted solution]

Hi,

You can refer this video

https://www.experiencesaphana.com/videos/1079

Rgds,

Murali

[Former Member]

Document below talks about this and partioning of HANA tables to overcome this.

https://service.sap.com/~sapidb/012006153200000616172011E/H1_SP3_Partitioning_en.pdf

[former_member182277]

Hello Kumar,

Two billion row limit is nothing but the records entry in the particular tables.

Like in Oracle we said tuple and in SAP HANA its consider as a row.

Regards,

neha

[former_member184768]

Hi Kumar,

There had been a discussion on the same topic in this forum earlier.

It is the number of records (rows) in the table. It is about horizontal partitioning of the data values.

Regards,

Ravi