{
 "type": "jdbc",
 "jdbc": {
    "url": "jdbc:mysql://localhost:3306/mydb",
    "user": "root",
    "password": "root",
    "sql": "a very big sql query;",
    "index": "my_index",
    "type": "providersForu"
  },
  "strategy" : "simple",
  "autocommit": true,
  "schedule":"0 0/1 * 1/1 * ? *",
  "ttl": {
     "enabled": true, "default":"5m"
  }
}

private SearchHit[] getSearchHitPhrase(String types, int indice) {
    //Search Request Builder

    QueryBuilder queryBuilder = QueryBuilders.matchAllQuery();
    queryBuilder = QueryBuilders.matchPhrasePrefixQuery(Constants.ES_FIELD_FILTRE, mot).slop(100).analyzer("stopwords_analyzer");
    SearchRequestBuilder searchRequest = client.prepareSearch()
            .setTypes(types)
            .setVersion(true)
            .setSize(Constants.PAGINATION_SIZE)
            .setFrom(indice)
            .setQuery(queryBuilder)
            .setExplain(true)
            .setSearchType(SearchType.DFS_QUERY_THEN_FETCH);

    // Executer la requete
    SearchResponse searchResponse = searchRequest.execute().actionGet();
    // Extrait les resultats
    return searchResponse.getHits().getHits();
}