How can we create a query in AWS CloudWatch Logs Insights that lists all the words from logs in order of frequency?

[mani0525]

I am dealing with cloudwatch logs, and I have a situation where I need to list all the words from the logs in order of their frequency. I have tried the following queries, but they haven't worked. If you could help, that would be greatly appreciated.

Query1:
fields @message
| parse @message /(?\<word\>\[^\\s\]+)/
| stats count() by word
| sort count() desc

Query2:
fields @message
| split " "
| stats count(*) by \*
| sort count\_* desc

list of all the terms from the cloud watch logs listed in frequency order

[nebulon]

Is this somehow in the context of Cloudron? I am asking, since this is a Cloudron related forum, however it is totally possible that others here are maybe able to help you out.