LIMIT is part of the syntax, perhaps I am confused.
See here
If the LIMIT or TOP is specified (cannot use both in the same query), the SELECT statement only returns a subset of the result rows. (See LIMIT Clause and TOP clause below.)
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.