We have around two billion claims from roughly three years. The client is interested in good data sampling, of let's say, 100 claims. They mention that with SQL, they do something like - order by newid()
, which fetches 100 random records from a table.
Any ideas how to do something similar with Hunk/Splunk?