Home

Welcome to the elasticsearch-sql wiki!

With this plugin you can query elasticsearch using familiar SQL syntax. You can also use ES functions in SQL.

There are two ways to use this plugin:

1. Using the rest api
   

http://localhost:9200/_sql?sql=select * from indexName limit 10

2. Web UI available at http://localhost:9200/_plugin/sql

Guides:

• Installation Guide
• Building and testing Guide

Features:

• Basic Queries And Conditions
• Geographic queries
• Aggregations
• Beyond SQL Features
• Scan and scroll
• Limited join support
• Show Commands
• Script Fields
• NestedTypes support
• Union & Minus support