This is a common question that we’ve encountered in the past during our PoC process.

Question:

Are there limitations on the number of rows or columns in a table?

Answer :

The numbering of rows is internally implemented on 64 bit integer, so at first view it seems the limitation is 2^64 rows. However, rows are collected in, so called, pack-rows each grouping 2^16 rows and pack-rows are numbered by using 32 bit signed integer. It means that we can not store more than 2^16*2^31=2^47 rows.
The columns are numbered by using 32 bit integer. However, the convention of naming the files storing column data uses 5 digits for column indicator. Thus, the limitation is 100.000 columns.