Hi,
Please help me…
Created Elastic search index using dynamic mapping
{
"settings": {
"index": {
"refresh_interval": "60s"
},
"index.requests.cache.enable": false,
"index.queries.cache.enabled": false,
"index.mapping.total_fields.limit": 100000,
"analysis": {
"filter": {
"nGram_filter": {
"type": "nGram",
"min_gram": 3,
"max_gram": 3,
"token_chars": [
"letter",
"digit",
"punctuation",
"symbol"
]
}
},
"analyzer": {
"nGram_analyzer": {
"type": "custom",
"tokenizer": "standard",
"filter": [
"lowercase",
"asciifolding",
"nGram_filter"
]
}
}
}
},
"mappings": {
"machineasset": {
"dynamic_templates": [
{
"full_contact": {
"path_match": "contact.*",
"mapping": {
"type": "text",
"term_vector": "yes",
"analyzer": "nGram_analyzer",
"index": true,
"copy_to": "full_contact"
}
}
},
{
"full_machinedetl": {
"path_match": "machinedetl.*",
"mapping": {
"type": "text",
"term_vector": "yes",
"analyzer": "nGram_analyzer",
"index": true,
"copy_to": "full_machinedetl"
}
}
}
],
"properties": {
"serverDate": {
"type": "date",
"index": "true",
"format": "strict_date_optional_time||epoch_millis"
}
}
}
}
}
using elastic search able to query data using
{
"query": {
"bool": {
"must": [
{
"term": {
"full_contact": "test"
}
}
]
}
}
}
Same datasource added in Grafana am able to query data like it returns values in table
Query : full_contact :"True" AND full_machinedetl:"PCI"
But when i try to display fields in option i don’t see column name full_contact ,full_machinedetl.
In elastic search head am able to see column name