PDFs

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

An integer is a sequence of digits.  Using the Analytics Query API, the LIMIT clause has maximum of 10,000 results. The Analytics Search UI caps the number of search results at 1000. If If ORDER BY is not specified in the query, the results sort in descending timestamp order. If a limit value higher than 10,000 is specified, the value is overridden with the maximum valueThe Analytics Search UI caps the number of search results at 1000 records.

Non-Aggregation Queries

Specify LIMIT N for non-aggregation queries to return the first N documents. 

SELECT * FROM transactions LIMIT 10

For non-aggregation queries, using the Analytics Query API, can return a maximum of 10,000 results. If a limit value higher than 10,000 is specified, the value is overridden with the maximum value.

Aggregation Queries

For aggregation queries a list of values is allowed. Each value applies to one "group by" term or bucketing function in the query. A "group by" term is a field name in an aggregation query. In the following example, field1 and field3 are group by terms, and series(field2, '1m') is a bucketing function:

...

The maximum number of buckets is 100. A larger value is overridden and replaced with the maximum of 100. Aggregation queries can return a maximum of 10000 results.

Info

REST API usage for limits is slightly different. Refer to the section "Querying Events" in Analytics Events API.

...