Specifies the maximum number of rows returned when a SQL statement containing an ORDER BY clause is executed. Cloudera Impala requires statements containing the ORDER BY clause to limit the number of rows returned. This option allows these statements to return a result set without specifying a limit in the application..
Valid Values
-1 | x
where:
x
is a positive integer that represents maximum number of rows returned.
Behavior
If set to -1 (disabled), there is no default limit the number of rows returned by a statement containing an ORDER BY clause. The application must limit the number of rows returned by SQL statements that contain an ORDER BY clause, or Impala will return an error.
If set to x, the number of rows returned by a SQL statement contining an ORDER BY clause are limited to the specified number of rows for the session. To override this value, specify a new value in a LIMIT clause in the statement that is being executed.
