Splunk Search

Pivot search won't work if it's accelerated, but works fine when acceleration is removed

Explorer

I currently have a simple constraint in a pivot datamodel which is:

index=video earliest=-5h-1d@d+5h latest=-5h@d+5h

This query by itself returns results.

However, when put as a constraint in a pivot and then querying by the pivot, no results are returned if the pivot is accelerated. Removing the acceleration however means results come through.

What can cause issues like this with accelerated pivots?

Anthony

1 Solution

Explorer

After speaking with support, they recommended not to put time modifiers in the query itself. It seems like the obscure modifier causes problems with the buckets.

Either way, the best way around it regardless of the actual root of the problem is to accelerate a portion of data that covers your time span, then add the modifiers when running the pivot command

View solution in original post

Explorer

After speaking with support, they recommended not to put time modifiers in the query itself. It seems like the obscure modifier causes problems with the buckets.

Either way, the best way around it regardless of the actual root of the problem is to accelerate a portion of data that covers your time span, then add the modifiers when running the pivot command

View solution in original post

Engager

I also have this issue. Anyone?

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!