Describe the bug
I have an elastic search cluster inside elastic official cloud and i can't connect to the cluster. When i try to do a show schemas for example, i receive the error:

ERROR o.a.calcite.jdbc.DynamicRootSchema - Failed to load schema for elastic_prod

java.lang.ClassCastException: null

I've launch a elastic single node in my local environment with docker and this elastic single node works perfectly.

To Reproduce

1. Create a elastic cluster inside elastic.cl
2. Add this cluster inside apache drill
3. Try to do a query, for example show schemas;

Expected behavior
It should do the expected query.

Error detail, log output or screenshots

ERROR o.a.calcite.jdbc.DynamicRootSchema - Failed to load schema for elastic_prod

java.lang.ClassCastException: null

Drill version
1.21.2
Additional context
Add any other context about the problem here.