### 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
failures.add(f);
                }
            });
            p.forEachExpression(Neg.class, neg -> {
                Failure f = validateUnsignedLongNegation(neg);
                if (f != null) {
                    failures.add(f);
                }
            });
        });
        
        if (failures.isEmpty()) {
            gatherMetrics(plan);
        }
        return failures;
    }
    private void gatherMetrics(LogicalPlan plan) {
        BitSet b = new BitSet(FeatureMetric.values().length);
        plan.forEachDown(p -> {
            if (p instanceof Dissect) {
                b.set(DISSECT.ordinal());
            } else if (p instanceof Eval) {
                b.set(EVAL.ordinal());
            } else if (p instanceof Grok) {
                b.set(GROK.ordinal());
            } else if (p instanceof Limit) {
                b.set(LIMIT.ordinal());
            } else if (p instanceof OrderBy) {
                b.set(SORT.ordinal());
            } else if (p instanceof Aggregate) {