Scaling Limits and Guidelines

This topic lists the scalability limitation in Impala. For a given functional feature, it is recommended that you respect these limitations to achieve optimal scalability and performance. For example, you might be able to create a table with 2000 columns, you will experience performance problems while querying the table. This topic does not cover functional limitations in Impala.

Unless noted otherwise, the limits were tested and certified.

The limits noted as "generally safe" are not certified, but recommended as generally safe. A safe range is not a hard limit as unforeseen errors or troubles in your particular environment can affect the range.

Deployment Limits

Data Storage Limits

There are no hard limits for the following, but you will experience gradual performance degradation as you increase these numbers.

Schema Design Limits

Security Limits

Query Limits - Compile Time

Query Limits - Runtime Time