code: public List<JSONObject> searchSimpleFilterElasticsearchQuery(String indexName, String mappingName, String
              columnName,
                                                                   Object value, String filterType) throws Exception {
          List<JSONObject> resultsJSON = new ArrayList<JSONObject>();
          QueryBuilder query;
          switch (filterType) {
              case "equals":
                  query = QueryBuilders.termQuery(columnName, value);
                  break;
              case "gt":
                  query = QueryBuilders.rangeQuery(columnName).gt(value);
                  break;
              case "gte":
                  query = QueryBuilders.rangeQuery(columnName).gte(value);
                  break;
              case "lt":
                  query = QueryBuilders.rangeQuery(columnName).lt(value);
                  break;
              case "lte":
                  query = QueryBuilders.rangeQuery(columnName).lte(value);
                  break;
              default:
                  throw new Exception("Filter not implemented in the library");
          }
  
          SearchResponse response = this.client.prepareSearch(indexName)
                  .setTypes(mappingName)
                  .setSearchType(SearchType.QUERY_AND_FETCH)
                  .setQuery(query)
                  .execute()
                  .actionGet();
          ImmutableOpenMap<Object, Object> aux = response.getContext();
          SearchHit[] results = response.getHits().getHits();
          for (SearchHit hit : results) {
              resultsJSON.add(new JSONObject(hit.getSourceAsString()));
          }
          return resultsJSON;
      }
docs: Simulate a SELET * FROM index.mapping WHERE (One simple filter)
  
  @param indexName
  @param mappingName
  @param columnName
  @param value
  @param filterType  [equals, gt, gte, lt, lte]
  @return ArrayList with all the rows(One element of the ArrayList is a JSON document)
  @throws Exception