Guy Shilo shows how you can write SQL to query Elasticsearch:
The mappings Elastic SQL uses are:
Index = Table
Document = Row
Field = Column
This mapping is quite intuitive. Types are left out because they are obsolete in Elastic 6.0 on.
So let’s give it a try. I used the latest Elastic 6.4 for this demonstration and ran the queries from Kibana, although they can be run with curl or just a browser as well. First we will need some data. I found this article in Elastic documentation that suggests several data files ready to be loaded. I did not need all of the data so I only used the json file that contains all the works of William Shakespeare that can be downloaded here.
Feasel’s Law continues.