./gradlew ":x-pack:plugin:esql:qa:server:single-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.single_node.EsqlSpecIT" -Dtests.method="test {csv-spec:lookup-join-expression.LookupJoinExpressionWithTerm}" -Dtests.seed=787C2B9F4B932B22 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=am-ET -Dtests.timezone=America/Martinique -Druntime.java=25

org.elasticsearch.client.ResponseException: method [GET], host [http://[::1]:39343], URI [/_query/async/Fk9UaDRkYllSU2ppTjk1a3Y0MXA5blEcZnFVUF9QY05UTGVyOG9pSGN5NGJ3QTozNDMxMA==?wait_for_completion_timeout=6000s&pretty=true&error_trace=true], status line [HTTP/1.1 400 Bad Request]
Warnings: [No limit defined, adding default limit of [1000]]
{
  "error" : {
    "root_cause" : [
      {
        "type" : "verification_exception",
        "reason" : "Found 1 problem\nline 3:47: Unsupported join filter expression:TERM(other1, \"beta\")",
        "stack_trace" : "org.elasticsearch.xpack.esql.VerificationException: Found 1 problem\nline 3:47: Unsupported join filter expression:TERM(other1, \"beta\")\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.verify(Analyzer.java:243)\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.analyze(Analyzer.java:237)\n\tat org.elasticsearch.xpack.esql.session.EsqlSession.analyzedPlan(EsqlSession.java:947)\n\tat org.elasticsearch.xpack.esql.session.EsqlSes
[truncated]