-
Notifications
You must be signed in to change notification settings - Fork 25.8k
Closed
Labels
:Analytics/ES|QLAKA ESQLAKA ESQL>bugTeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)Meta label for analytical engine team (ESQL/Aggs/Geo)
Description
from sample_data_str,app_logs,fi*
| sort service_id, client_ip DESC, destination.IP NULLS FIRST
| eval xJRwHRezpds = -1299206307, ZuPpUkXhu = -1360937430036226416, `source.IP` = \"IizPcFyV\" | keep xJRwHRezpds, `source.IP`
| rename `source.IP` AS `dVxoyvSH`| rename dVxoyvSH as message
| lookup join message_types_lookup on message
| drop xJRwHRezpds, *Rezpds
| mv_expand message
| dissect message \"%{RQZzvsuaWfI}\"
| rename RQZzvsuaWfI AS `message`, `message` AS FJaUmggBPj
| dissect FJaUmggBPj \"%{FJaUmggBPj} %{FJaUmggBPj}\" | rename FJaUmggBPj AS `FvgUVtLZjcGv`
| grok FvgUVtLZjcGv \"%{WORD:FvgUVtLZjcGv}\"
| eval DRfKHTdnx = 1146940792054680116, FvgUVtLZjcGv = null
| keep *
...
"columns": [
{
"name": "type",
"type": "keyword"
},
{
"name": "DRfKHTdnx",
"type": "long"
},
{
"name": "FvgUVtLZjcGv",
"type": "null"
}
],
...
Same query, but without KEEP *
from sample_data_str,app_logs,fi*
| sort service_id, client_ip DESC, destination.IP NULLS FIRST
| eval xJRwHRezpds = -1299206307, ZuPpUkXhu = -1360937430036226416, `source.IP` = \"IizPcFyV\" | keep xJRwHRezpds, `source.IP`
| rename `source.IP` AS `dVxoyvSH`| rename dVxoyvSH as message
| lookup join message_types_lookup on message
| drop xJRwHRezpds, *Rezpds
| mv_expand message
| dissect message \"%{RQZzvsuaWfI}\"
| rename RQZzvsuaWfI AS `message`, `message` AS FJaUmggBPj
| dissect FJaUmggBPj \"%{FJaUmggBPj} %{FJaUmggBPj}\" | rename FJaUmggBPj AS `FvgUVtLZjcGv`
| grok FvgUVtLZjcGv \"%{WORD:FvgUVtLZjcGv}\"
| eval DRfKHTdnx = 1146940792054680116, FvgUVtLZjcGv = null
...
"columns": [
{
"name": "DRfKHTdnx",
"type": "long"
},
{
"name": "FvgUVtLZjcGv",
"type": "null"
}
],
...
A KEEP * shouldn't change the columns returned.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
:Analytics/ES|QLAKA ESQLAKA ESQL>bugTeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)Meta label for analytical engine team (ESQL/Aggs/Geo)