Limits the number of returned records.
If you do not specify the limit, the query renders 1000 results (this limit, by default, is appended as the last line of the query).
You can increase or decrease the limit depending on your needs. Changing the limit has an impact on your DDU consumption and query execution time.
| limit numberOfRqueryecords
Example1fetch logs2| limit 10
Sorts the records. The default sorting order is descending. You can control the order in which your records are displayed by adding
asc for ascending and
desc for descending.
| sort fieldname [asc | desc][, ...]
Example1fetch events2| sort timestamp desc, event.type asc