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:calcite:model=./cassandra/src/test/resources/modelPost.json admin admin 2017-10-05 21:31:28,668 [main] INFO - [Dum-Dum Dugan] modules [], plugins [], sites [] 0: jdbc:calcite:model=./cassandra/src/test/re> select * from "elasticsearch".movie; +------+ | _MAP | +------+ | {YEAR=1972, MID=1, TITLE=The Godfather, DIRECTOR=Francis Ford Coppola} | +------+ 1 row selected (2.057 seconds) 0: jdbc:calcite:model=./cassandra/src/test/re> Now If I want to query a specific field inside the map , what should the query look like . I am able to retrieve all the information by the query - select * from "elalsticsearch".movie; "elasticsearch" = schema "movie" = type Now If I want to query only the title name from the type, Could you please let me know the syntax. Thanks, Ashwin
