### Elasticsearch Version

8.11.0

### Installed Plugins

_No response_

### Java Version

_bundled_

### OS Version

MacOS

### Problem Description

I would expect a clear message for the following ES|QL query:

```
from index | where 1 year
```

But what I get is:

```
[esql] > Unexpected error from Elasticsearch: illegal_argument_exception - Unrecognized class type class java.time.Period
```

### Steps to Reproduce

See above.

### Logs (if relevant)

_No response_
x-pack/plugin/esql/src/main/java/org/elasticsearch/xpack/esql/analysis/Verifier.java
}
                });
            } else if (p instanceof RegexExtract re) {
                Expression expr = re.input();
                DataType type = expr.dataType();
                if (EsqlDataTypes.isString(type) == false) {
                    failures.add(
                        fail(
                            expr,
                            "{} only supports KEYWORD or TEXT values, found expression [{}] type [{}]",
                            re.getClass().getSimpleName(),
                            expr.sourceText(),
                            type
                        )
                    );
                }
            } else if (p instanceof Row row) {
                failures.addAll(validateRow(row));
            } else if (p instanceof Eval eval) {
                failures.addAll(validateEval(eval));
            }
            p.forEachExpression(BinaryOperator.class, bo -> {
                Failure f = validateUnsignedLongOperator(bo);
                if (f != null) {
                    failures.add(f);
                }
            });
            p.forEachExpression(BinaryComparison.class, bc -> {
                Failure f = validateBinaryComparison(bc);
                if (f != null) {