table size limitations

2 posts / 0 new
Last post
idokara
idokara's picture
Offline
Last seen: 1 month 4 days ago
Joined: Mar 2 2014
Junior Boarder

Posts: 6

Ido Karavany
table size limitations

I have tried to create a table with more than 4096 columns and failed since it seems there is a limitation on the number of columns as in normal MySQL DB. 

Am I doing something wrong or there is such a limit, since InfiniDB is a columnar DB I expected for not such limit to exists

 

 

thanks in advanced 

Dana

radams
radams's picture
Offline
Last seen: 3 hours 45 sec ago
Joined: Jan 3 2011
Administrator

Posts: 493

Robert Adams
table size limitations

 

Hi Dana,

 

There are limits on the number of columns in a table and an error will also be generated when the row size is too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

 

Thanks,

 

Robert