on 09-05-2013 9:45 AM
Hi,
what's the max No of columns for a:
ThanXs
Martin
Hi Martin,
Please refer to the Table and SQL limits as mentioned here. (Restrictions for SQL Statements in SQL Reference). You can also check the system view M_SYSTEM_LIMITS in your HANA database to get more details.
Hope this helps.
Out of curiosity, is this information required for Information purpose or you are trying to test the limits of HANA.
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
its not curiosity its a need:
While migrating from Oracle to a SAP HANA BW I came over the max no of columns of a Hana table and want to know how many no of columns a Hana ( row and column Table) can
have.
So I need to build a Calc. Analy. View - There I wonder also what would be the my number of columns.
Thank You
Martin
Hello Martin,
As per SAP standard model on HANA Studio SP06, below is the max. limit:
Tables and Views |
|
Number of columns in a table | 1000 |
Number of columns in a view | 1000 |
Number of partitions of a column table | 1000 |
Number of rows in each table | Limited by storage size RS: 1TB/sizeof(row), CS: 2^31 * number of partitions |
Regards,
Biswa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.