Limits

Values for version 1.01. Names are lower case letters, digits and underscores, starting with a letter.

Names

• Table names: 31 characters at most.
• Column names: 63 characters at most.
• User names and passwords: 31 characters at most, no blank.

Tables

• A narrow table has at most 1500 columns. Above that the table is wide (see Wide or narrow tables).
• A create table statement defines at most 1024 columns. To create a table with more columns, create it empty (or wide) and add columns with alter table.
• A table has 1, 2 or 3 replicates.
• The query that creates a table is kept in the dictionary: if it is too long for the dictionary, create the table empty and add the columns with alter table.

Statements and results

• A statement is at most 128 MB long.
• A result row is at most 64 KB of data and 2048 columns.
• A join involves at most 16 tables.
• In a select, a column or table name is at most 64 characters, and a table alias at most 31.

The cluster

• The number of data brokers is limited by the license. show cluster shows the maximum and the current count.
• All clocks of the brokers must agree (the brokers authenticate each other with time-stamped signatures that tolerate 2 minutes of difference).