[CI] CsvTests test {categorize.Categorize} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #4106 / release-tests
• elasticsearch-periodic #4102 / release-tests
• elasticsearch-periodic #4094 / release-tests
• elasticsearch-periodic #4090 / release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.CsvTests" -Dtests.method="test {categorize.Categorize}" -Dtests.seed=1B28BB1C30714205 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=en-JE -Dtests.timezone=Asia/Saigon -Druntime.java=22

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.xpack.esql.VerificationException: Found 1 problem
line 2:59: Unknown function [CATEGORIZE]

Issue Reasons:

• [main] 4 consecutive failures in step release-tests
• [main] 4 failures in test test {categorize.Categorize} (1.3% fail rate in 307 executions)
• [main] 4 failures in step release-tests (100.0% fail rate in 4 executions)
• [main] 4 failures in pipeline elasticsearch-periodic (80.0% fail rate in 5 executions)

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

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[astefan]

@jan-elastic this one failed in a release test. We should look into conditionally have the specific test checked for release/non-release CI runs, since this function is not meant to be available in a release version.

[jan-elastic]

#113089