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

[anthony_copus]

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

[anthony_copus · Accepted solution]

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

[kkentsplunk]

I also have this issue. Anyone?