Limits
This topic lists the Dremio limits.
| Type | Limit | Comments |
|---|---|---|
| Catalog | 32k | Size of fields in records. |
| Catalog | 800 | Number of columns in tables. |
| Source | 60,000 | The number of splits that can be processed for a single dataset (table) for FileSystem Sources |
| Source | 300,000 | The number of splits that can be processed for a single dataset (table) for Non-FileSystem Sources |
| Source | 300,000 | The combined number of splits that can be processed from all datasets (tables) referenced in a query for both FileSystem Sources & Non-FileSystem Sources, after Dremio has pruned partitions for each dataset. |
| Configuration | 25,000 | Number of nodes in a query plan. |
| Workload Management | 1000 | Total number of executing and queued queries in the system. |
| Uploads | 500MB | The number of bytes that can be uploaded through the UI |
| Downloads | 1M rows | The number of rows that can be downloaded through the UI |