The Impala Query Language and Built-in Functions - Learning Cloudera Impala - page 77

BY column_name
HAVING aggregate_function(column_name)
operator value;
• LIMIT : Sometimes, when you want to limit the results of a SELECT query, you
can use the LIMIT clause to set the maximum number of rows in the result
set. The syntax of the LIMIT clause is as follows:
SELECT column_name(s) FROM table_name
LIMIT number;