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",

"ean":"abcdefghijklmnopqsrtuvwxyz",

"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,....~"

}

}

Elasticsearch

ID Projekti: #16485274

Rreth projektit