Group By in Elastic Search


(vijuitech) #1

Hi,
Is there any feature in Elasticsearch to search as GROUP BY In
SQL? For Example:

Name Rank

xxxx 1

yyyyy 2

xxxx 1

zzzz 1

Is there any feature in Elasticsearch to search by unique name?

so that the output in should be

Name Rank

xxxx 1

yyyyy 2

zzzz 1

Cheers!

George


(David Pilato) #2

Facets could answer to your needs if you want to compute datas.

HTH
David :wink:
@dadoonet

Le 14 mars 2012 à 07:34, George Viju vijuitech@gmail.com a écrit :

Hi,
Is there any feature in Elasticsearch to search as GROUP BY In
SQL? For Example:

Name Rank

xxxx 1

yyyyy 2

xxxx 1

zzzz 1

Is there any feature in Elasticsearch to search by unique name?

so that the output in should be

Name Rank

xxxx 1

yyyyy 2

zzzz 1

Cheers!

George


(vijuitech) #3

Thanks David.. Will the search response itself gets the unique data
which is grouped by Name? How can we fetch the data in which the
response should return the unique data which is grouped by Name?

Cheer!
George
On Mar 14, 11:53 am, David Pilato da...@pilato.fr wrote:

Facets could answer to your needs if you want to compute datas.

HTH
David :wink:
@dadoonet

Le 14 mars 2012 à 07:34, George Viju vijuit...@gmail.com a écrit :

Hi,
Is there any feature in Elasticsearch to search as GROUP BY In
SQL? For Example:

Name Rank

xxxx 1

yyyyy 2

xxxx 1

zzzz 1

Is there any feature in Elasticsearch to search by unique name?

so that the output in should be

Name Rank

xxxx 1

yyyyy 2

zzzz 1

Cheers!

George


(system) #4