curl -H "Content-Type: application/json" -XGET
'http://localhost:9200/social-*/_search' -d '{
 "query": {
  "match": {
   "message": "myProduct"
  }
 },
 "aggregations": {
  "top_10_states": {
   "terms": {
    "field": "state",
    "size": 10
   }
  }
 }
}'

RestHighLevelClient client = new RestHighLevelClient(RestClient.builder(
          new HttpHost("localhost", 9200, "http")));

SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
searchSourceBuilder.query(QueryBuilders.matchAllQuery());      
searchSourceBuilder.aggregation(AggregationBuilders.terms("top_10_states").field("state").size(10));

SearchRequest searchRequest = new SearchRequest();
searchRequest.indices("social-*");
searchRequest.source(searchSourceBuilder);
SearchResponse searchResponse = client.search(searchRequest);

use Search::Elasticsearch;
my $esclient = Search::Elasticsearch->new(
 nodes => 'localhost:9200'
);
my $response = $esclient->search(
 index => 'social-*',
 body => {
  query => {
   match => { message => 'myProduct' }
  },
  aggs => {
   top_10_states => {
    terms => {
     field => 'state',
     size => 10
    }
   }
  }
 }
);

$esclient = Elasticsearch\ClientBuilder::create()
  ->setHosts(["localhost:9200"])
  ->build();
$params = [
  'index' => 'social-*',
  'body' => [
    'query' => [
      'match' => ['message' => 'myProduct']
    ],
    'aggs' => [
      'top_10_states' => [
        'terms' => [
          'field' => 'state',
          'size' => 10,
        ]
      ]
    ]
  ]
];
$response = $esclient->search($params);

from elasticsearch import Elasticsearch

esclient = Elasticsearch(['localhost:9200'])
response = esclient.search(
  index='social-*',
  body={
    "query": {
      "match": {
        "message": "myProduct"
      }
    },
    "aggs": {
      "top_10_states": {
        "terms": {
          "field": "state",
          "size": 10
        }
      }
    }
  }
)

require 'elasticsearch'

esclient = Elasticsearch::Client.new(host: 'localhost:9200')
response = esclient.search index: 'social-*', body: {
 query: {
  match: {
   message: 'myProduct'
  }
 },
 aggregations: {
  top_10_states: {
   terms: {
    field: 'state',
    size: 10
   }
  }
 }
}

SELECT SCORE(), * FROM "social-*" 
  WHERE match(message, 'myProduct') 
  ORDER BY SCORE() DESC

SELECT state, COUNT(*) AS state_count FROM "social-*" 
  WHERE match(message, 'myProduct') 
  GROUP BY state
  ORDER BY COUNT(*) 
  LIMIT 10