The open source Elasticsearch database powers log analysis tools for many systems at OpenDNS. Coupled with the projects Kibana and Logstash, we use Elasticsearch to gain insight into who is using our systems in real time. While its powerful search functions work excellently for logs, Elasticsearch also powers high-traffic systems like Wikipedia search and Github search.
This week at OpenLate, Shaunak Kashyap from Elastic (the parent company for Elasticsearch) presented how to translate SQL queries to Elasticsearch queries. SQL is one of the most universal ways to query structured data, so this tutorial provides a useful way to transfer knowledge to Elasticsearch.
Join OpenLate meetups in San Francisco and Vancouver for tech talks and hack nights at OpenDNS offices.