Size limit for a single Hana DB Table

[former_member204167]

Hi Experts,

I just wonder if there is a limit for the number of lines in a single SAP HANA DB Table. It's clear that there is a technical limit regarding the memory/disc space. But is there also a technical limitation for the number of lines in a single table. I am asking because we have a business process where we need to store (theoretically) up to 100 billion records in a single table. Would it be necessary to use partitioning in such a case or would it be possible to store this in a single table (assuming we have enough memory/disc space)?

Regards

Tobias

[michael_eaton3 · Accepted solution]

This reference might be useful Restrictions for SQL Statements - SAP HANA SQL and System Views Reference - SAP Library

Michael

[former_member204167 · Accepted solution]

Hi Michael,

Thanks for your help. Nevertheless, I am little bit confused now. I found the following in the SAP HANA Reference in the "Table Partition" Section:

"Overcoming the size limitation of column-store tables

A non-partitioned table cannot store more than 2 billion rows. It is possible to overcome this limit by distributing the rows across several partitions. Each partition must not contain more than 2 billion rows."

In the link you sent I found the following:

What does this value of 2^31 * number of partions represent. 2^31 is much bigger than 2 billion records.

P.S.: In my use case I will clearly have a column-base storage.

Regards

Tobias

[Bojan-lv-85 · Accepted solution]

Hello Tobias,

with 2bn we of course mean 2147483648

So per partition 2147483648 rows are possible.

Greetings,

Bojan

[former_member204167 · Accepted solution]

Hi Bojan,

i was just to dumb to use my calculator correctly. Instead of 2^31, I accidently calculated 2*10^31 . That's why I was wondering about this HUGE difference to 2 billion records. When 2^31 is actually 2147483648 everything is clear to me now

Thanks for your help guys.

Regards

Tobias

[michael_eaton3]

There is no realistic limit to the number of rows in a table, however there is a limit to the number of rows in a partition - 2 billion.  By default a table with no explicit partitions defined is considered a single partition.

Michael