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.
There are no hard limits for the following, but you will experience gradual performance degradation as you increase these numbers.
See Kudu Usage Limitations for more information.
SELECT list,
INSERT, and in an expression: no limit
disable_codegen=true may reduce the impact, at a cost of longer
query runtime.