Solve query and meet all requirements against ElasticSearch 6.0.1 and suggest alternatives and improvements for performance

Looking for a proper search result on a product search against ElasticSearch 6.0.1.

TASK: Create a Query applying following requirements on ES REST API with best possible performance config and at least 5 suggestions for performance related queries and on existing data.

Access to ES will be given and results will be documented and delivered on a postman collection.

0. use columns Name, Brand, Description, LongDescription.

1. Text case override, match ie: `same = Same = SAME`

2. All words found OR some words found, text = running boots red, first results that contain 3 words then 2 words and then 1.

3. In case of match from 1 word only, then give priority to results only matching certain column/attribute. ie: `Brand +2, Name +1`

4. In case of no match give related results to words on another column.

5. Remove duplicates or prevent part of a column value to be same in other row. ie: from ean:"abcdefghijklmnopqsrtuvw**xyz**" use "abcdefghijklmnopqsrtuvw" and remove all other matching substring.

6. Text search with ASCII Folding Token Filter on this ES version

Thanks in advance for your assistance.


Sample data:


"took": 2,

"timed_out": false,

"_shards": {

"total": 5,

"successful": 5,

"skipped": 0,

"failed": 0


"hits": {

"total": 92933,

"max_score": 0.9849872,

"hits": [


"_index": "product",

"_type": "products",

"_id": "***7c19ee74212ecf6fc48e85cad",

"_score": 0.9849872,

"_source": {

"id": "***c19ee74212ecf6fc48e85cad",


"name": "Montane Minimus chaqueta elástica para exteriores de mujer - AW17",

"brand": "Montane",

"price": 164.15,

"currency": "EUR",

"url": "[url removed, login to view][[producto/mon1266]]",

"image": "",

"bigImage": "https://cdn.~.com/product/M/MON1266/[url removed, login to view]",

"description": "Creada con un materials upertranspirante Pertex Shield+ ....~",

"longDescription": "Montane Minimus chaqueta elástica para exteriores de mujer - AW17 Creada con un material supertranspirante Pertex Shield+ Denier 20 con una capa de fibra de 2.5,....~"



Habilidades: Elasticsearch

Veja mais: employee strengths and areas of improvement, areas of improvement appraisal, areas for improvement examples, list of development areas for employees, areas of improvement in appraisal form examples, areas of improvement performance review examples, list of areas of improvement for employees, needs improvement examples, http://v.youku.com/v_show/id_XMTYyMzM1MzE5Ng==.html?from=y1.2-1-87.3.7-1.1-1-1-6-0, www google com search biw 1093&bih 478&tbm isch&sa 1&q logo design mje&oq logo design mje&gs_l img 3 52853.53831 0.54137 7.6 0.0, visual basic 6.0 coding, visual basic 6.0, visual basic 6 0, Vb 6.0, smart wear product design, sap ecc 6.0 free online access, programming microsoft visual basic 6.0, programming in visual basic 6.0, programador visual basic 6.0 freelance, necesito programador visual basic 6.0

Acerca do Empregador:
( 3 comentários ) Torrelles de llobregat, Spain

ID do Projeto: #16485274

5 freelancers estão ofertando em média €143 para esse trabalho


I have experience in elastic search in my current employment though i only have months experience. But i can help based on the task you included on the description if you would let me.

€166 EUR in 3 dias
(0 Comentários)

Hi! I have 11+ years of web developing experience. Main skills: PHP, MYSQL, MONGODB, JAVASCRIPT, ELASTICSEARCH, JQUERY, AJAX, HTML, CSS, XML, JSON, CODEIGNITER, KOHANA, LARAVEL, SYMFONY, PHALCON I can promise quali Mais

€150 EUR em 1 dia
(0 Comentários)

I have worked on ELK stack, I can help you create an efficient query. I can complete the task in 2 days

€111 EUR in 2 dias
(0 Comentários)

I have 2+ years of Elasticsearch exposure... specailly focussing on search refinements and have widely used widlcard,prefix, ngrams etc

€150 EUR in 3 dias
(0 Comentários)

Have been working on ELK(Elasticsearch,Logstash and Kibana) stack from 4 years and have developed more than 8 search engines using Elasticsearch. One of the search engine is being used by VMware for searching their Mais

€138 EUR in 3 dias
(0 Comentários)