Did you take a look in the test cases for some examples of use?
https://github.com/apache/calcite/blob/master/elasticsearch5/src/test/java/org/apache/calcite/test/Elasticsearch5AdapterIT.java
What have you tried?
Your problem, again, is about the names being case sensitive.
Try using double quotes around column and table names to make sure they are
interpreted correctly or use them all in uppercase, both in the json model and
in the query.
You can also set a different lex property for the connection