Displays statistics about the fields within the current event stream.
The function returns an event set that contains statistics for the fields in the current event set; the returned fields include:
The name of the parsing used when the data was ingested.
field
The name of field for the statistics.
_count
The number of values for the named field within the incoming event set.
distinct
The number of distinct values for the named field in the incoming event set.
fieldstats() Examples
Click next to an example below to get the full details.
Extract Field Statistics
Extract field statistics from a repository using the
fieldstats() function
Query
fieldstats()Introduction
In this example, the fieldstats() function is used
to get the statistics for the fields #type,
field,
_count and
distinct within the
HUMIO repository. The example will only
show the first 20 rows (but the
limit parameter has a
default value of 200 rows.
Step-by-Step
Starting with the source repository events.
- logscale
fieldstats()Extracts statistics about fields within the humio respository.
Event Result set.
Summary and Results
The query is used to extract statistics about the fields within a current event stream. The process of extracting insights from data streams in real time or near-real time can be used to identify and act on critical business moments, collect data from various sources, and to understand the meaning of this data and its content. Statistics are useful for analyzation.
Sample output from the incoming example data (showing the first 20 rows only):
| #type | field | _count | distinct |
|---|---|---|---|
| humio | decodedContentLength | 60501 | 107 |
| humio | originalName | 154824 | 19 |
| humio | tx_fifo | 16296 | 1 |
| humio | humioClass | 1641588 | 320 |
| humio | p75 | 268658 | 42439 |
| humio | bucketId | 234418 | 2 |
| humio | dataspaceId | 10077935 | 56 |
| humio | userAgent | 61675 | 7 |
| humio | datasource | 9037297 | 143 |
| humio | request-rate | 43678 | 24248 |
| humio | topic_leader_size | 18611 | 16112 |
| humio | readOnly | 158036 | 1 |
| humio | request-latency-avg | 39542 | 7169 |
| humio | @rawstring | 17517915 | 17696022 |
| humio | percentDone | 85431 | 39209 |
| humio | uri | 61675 | 325 |
| humio | tx_carrier | 16296 | 1 |
| humio | p98 | 268658 | 45969 |
| humio | totalCount | 42731 | 9 |
| humio | s3AccessConfig | 158036 | 1 |