Hi devs,
I have created an index called Movies and a type called Movie inside it.
Below is the structure -
curl -XPUT "http://localhost:9200/movies/MOVIE/1"; -d'
{
"MID" : "1",
"TITLE": "The Godfather",
"DIRECTOR": "Francis Ford Coppola",
"YEAR": 1972
}'
sqlline> !connect
jdbc
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