I was trying to accelerate a search with join command(trying to accelerate two searches). When I look at the job inspector, it says the search is using summaries for the search. But I think only the first search is accelerated and the second search is executes normally because the job inspector doesn't show the subsearch using any summaries.
I also tried accelerating the searches separately, with the expectation that each search in the combined search (search with JOIN) would match with the individual accelerated search and use the summary for searching. However the combined search only uses the summary created by the first search.
Lets say if this is the structure of the search
index=myindex sourcetype=sourcetype1 | eval something =1| stats count(something) as count by somethingelse |JOIN somethingelse [search index=myindex sourcetype=sourcetype2|stats max(splunk_is_awesome) as max by somethingelse] | table somethingelse max count
In the above search
index=myindex sourcetype=sourcetype1 | eval something =1| stats count(something) as count by somethingelse
gets accelerated but the subsearch doesn't get accelerated
index=myindex sourcetype=sourcetype2|stats max(splunk_is_awesome) as max by somethingelse
Any thoughts ??
... View more