[CI] RandomizedTimeSeriesIT testRateGroupBySubset failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #10403 / almalinux-9_platform-support-unix
• elasticsearch-pull-request #88732 / part-3
• elasticsearch-pull-request #88715 / part-3
• elasticsearch-pull-request #88667 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.RandomizedTimeSeriesIT.testRateGroupBySubset" -Dtests.seed=E2AD0636713CB8F0 -Dtests.locale=kxv-Telu-IN -Dtests.timezone=America/Atikokan -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.xpack.esql.parser.ParsingException: line 6:116: no viable alternative at input 'attributes.Not'

Issue Reasons:

• [main] 4 failures in test testRateGroupBySubset (0.7% fail rate in 548 executions)
• [main] 3 failures in step part-3 (1.4% fail rate in 209 executions)
• [main] 3 failures in pipeline elasticsearch-pull-request (1.4% fail rate in 207 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 4 failures in test testRateGroupBySubset (0.7% fail rate in 548 executions)
• [main] 3 failures in step part-3 (1.4% fail rate in 209 executions)
• [main] 3 failures in pipeline elasticsearch-pull-request (1.4% fail rate in 207 executions)

Build Scans:

• elasticsearch-periodic-platform-support #10403 / almalinux-9_platform-support-unix
• elasticsearch-pull-request #88732 / part-3
• elasticsearch-pull-request #88715 / part-3
• elasticsearch-pull-request #88667 / part-3

[elasticsearchmachine]

Pinging @elastic/es-storage-engine (Team:StorageEngine)

[kkrik-es]

Let's make sure we test with 1000 iterations before updating randomized tests.

[pabloem]

this is also fixed by #134092