SQL interface to Elasticsearch & Aggregation functions


(pranav amin) #1

Hey guys,

Is there any SQL interface to Elasticsearch? Or if there is any code
written in Perl or python where i can just input my query and it can
provide me the results would be great too.
The output can be in any format as long as i can write a SQL query in the
code.

Also does Elastic search support the below aggregrated -
Sum, Group by, Having, First, Last, etc?

Thanks
Pranav.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.


(sina.tamanna) #2

Elasticsearch is not meant to be RDBM therefore it does not include
functionalities available in RDBMs. Perhaps you can explain your use case
so that people could show you possible solutions specific for your problem.

As for the aggregated stuff, take a look at facetshttp://www.elasticsearch.org/guide/reference/api/search/facets/
.

On Wednesday, September 11, 2013 11:00:13 PM UTC+2, pranav amin wrote:

Hey guys,

Is there any SQL interface to Elasticsearch? Or if there is any code
written in Perl or python where i can just input my query and it can
provide me the results would be great too.
The output can be in any format as long as i can write a SQL query in the
code.

Also does Elastic search support the below aggregrated -
Sum, Group by, Having, First, Last, etc?

Thanks
Pranav.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.


(Raffaele Sena) #3

I wrote this in order to run some queries against ElasticSearch used as a
database (my fault for storing the data in ES instead of MySQL, but it
worked pretty well)

(python, but there is an equivalent version in java at
https://github.com/raff/elseql-j)

You can run some aggregate-style queries using facets, and some other by
using scripts.

-- Raffaele

On Wed, Sep 11, 2013 at 11:54 PM, sina.tamanna@gmail.com wrote:

Elasticsearch is not meant to be RDBM therefore it does not include
functionalities available in RDBMs. Perhaps you can explain your use case
so that people could show you possible solutions specific for your problem.

As for the aggregated stuff, take a look at facetshttp://www.elasticsearch.org/guide/reference/api/search/facets/
.

On Wednesday, September 11, 2013 11:00:13 PM UTC+2, pranav amin wrote:

Hey guys,

Is there any SQL interface to Elasticsearch? Or if there is any code
written in Perl or python where i can just input my query and it can
provide me the results would be great too.
The output can be in any format as long as i can write a SQL query in the
code.

Also does Elastic search support the below aggregrated -
Sum, Group by, Having, First, Last, etc?

Thanks
Pranav.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #4