SQL to query data from ElasticSearch

Elastic Stack Elasticsearch
1

Hi,

I am looking for a solution to query data indexed in ElasticSearch using
SQL-like language instead of the ElasticSearch REST API. The solution may
be something built on top of the the REST API but what I really need is
just an interface to query data using SQL or something close to SQL without
having all the features of it.

The reason why I want something like this is because I am working on a
project wherein I need to expose querying data from ElasticSearch to a very
small subset of users, who are developers. Since they are developers, SQL
comes more naturally to them and working with it is rather easy as compared
to learning a new interface for querying data.

Thanks,
Vaidik

--

2

I can recommand to use a QueryString query.
You can use Lucene Query Syntax. You don't need to reinvent the wheel here.

If your users are developpers, they will understand very quick all the basics.

See
http://lucene.apache.org/core/4_0_0/queryparser/org/apache/lucene/queryparser/classic/package-summary.html#package_description

HTH

Le 26 décembre 2012 à 13:56, Vaidik Kapoor kapoor.vaidik@gmail.com a écrit :

Hi,

I am looking for a solution to query data indexed in Elasticsearch using
SQL-like language instead of the Elasticsearch REST API. The solution may be
something built on top of the the REST API but what I really need is just an
interface to query data using SQL or something close to SQL without having all
the features of it.

The reason why I want something like this is because I am working on a
project wherein I need to expose querying data from Elasticsearch to a very
small subset of users, who are developers. Since they are developers, SQL
comes more naturally to them and working with it is rather easy as compared to
learning a new interface for querying data.

Thanks,
Vaidik

--

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--

3

This is in python, but if you are fine with a command-line tool (or python) it does the job.
I also have a java version, but didn't have the time to publish it just yet.

-- Raffaele

Sent from my iPad

On Dec 26, 2012, at 4:56 AM, Vaidik Kapoor kapoor.vaidik@gmail.com wrote:

Hi,

I am looking for a solution to query data indexed in Elasticsearch using SQL-like language instead of the Elasticsearch REST API. The solution may be something built on top of the the REST API but what I really need is just an interface to query data using SQL or something close to SQL without having all the features of it.

The reason why I want something like this is because I am working on a project wherein I need to expose querying data from Elasticsearch to a very small subset of users, who are developers. Since they are developers, SQL comes more naturally to them and working with it is rather easy as compared to learning a new interface for querying data.

Thanks,
Vaidik

--

4

Hi,

While not a direct answer to your question, see Sensei's BQL - maybe you
can adapt/borrow from it.

http://senseidb.com/bql.html

Otis

ELASTICSEARCH Performance Monitoring - Sematext Monitoring | Infrastructure Monitoring Service
Search Analytics - Cloud Monitoring Tools & Services | Sematext

On Wednesday, December 26, 2012 7:56:03 AM UTC-5, Vaidik Kapoor wrote:

Hi,

I am looking for a solution to query data indexed in Elasticsearch using
SQL-like language instead of the Elasticsearch REST API. The solution may
be something built on top of the the REST API but what I really need is
just an interface to query data using SQL or something close to SQL without
having all the features of it.

The reason why I want something like this is because I am working on a
project wherein I need to expose querying data from Elasticsearch to a very
small subset of users, who are developers. Since they are developers, SQL
comes more naturally to them and working with it is rather easy as compared
to learning a new interface for querying data.

Thanks,
Vaidik

--

5

Vaidik have you looked at Apache Drill ?

6

This should be your choice i believe.

On Wednesday, December 26, 2012 at 8:56:03 PM UTC+8, Vaidik Kapoor wrote:

Hi,

I am looking for a solution to query data indexed in Elasticsearch using
SQL-like language instead of the Elasticsearch REST API. The solution may
be something built on top of the the REST API but what I really need is
just an interface to query data using SQL or something close to SQL without
having all the features of it.

The reason why I want something like this is because I am working on a
project wherein I need to expose querying data from Elasticsearch to a very
small subset of users, who are developers. Since they are developers, SQL
comes more naturally to them and working with it is rather easy as compared
to learning a new interface for querying data.

Thanks,
Vaidik

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/44088862-c37f-4f19-bc86-7e8485f8165d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

7

What did you use to parse SQl to Elasticsearch query? Any kind of compiler
like yacc?

2015-03-04 4:58 GMT-03:00 Johnny Wang archer.wq@gmail.com:

GitHub - NLPchina/elasticsearch-sql: Use SQL to query Elasticsearch

This should be your choice i believe.

On Wednesday, December 26, 2012 at 8:56:03 PM UTC+8, Vaidik Kapoor wrote:

Hi,

I am looking for a solution to query data indexed in Elasticsearch using
SQL-like language instead of the Elasticsearch REST API. The solution may
be something built on top of the the REST API but what I really need is
just an interface to query data using SQL or something close to SQL without
having all the features of it.

The reason why I want something like this is because I am working on a
project wherein I need to expose querying data from Elasticsearch to a very
small subset of users, who are developers. Since they are developers, SQL
comes more naturally to them and working with it is rather easy as compared
to learning a new interface for querying data.

Thanks,
Vaidik

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/44088862-c37f-4f19-bc86-7e8485f8165d%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/44088862-c37f-4f19-bc86-7e8485f8165d%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
Regards,

Sávio S. Teles de Oliveira

Co-Founder & Software Engineer at www.gogeo.io.
PHD student in Computer Science focusing on High Performance Maps Platform
and Spatial Algorithms.
voice: +55 62 9136 6996
http://br.linkedin.com/in/savioteles
https://twitter.com/savioteless

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAFKmhPvVd_7JLZ_ZPe7HcRLRDe5JyphRcbjbZjY_cp2Ya4H%3DvA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.