I have created following mapping for in ElasticSearch and same is created. But when I add documents to this type, my nested field type changes to normal. So when I execute query on nested object fields,it shows unexpected results while on rest of the fields results are as expected. I am not sure what I am doing wrong. There must be something I am missing while creating nested object mapping.
{
"li-new": {
"settings":{
"index":{
"analysis":{
"analyzer":{
"standard":{
"tokenizer":"standard",
"filter":["lowercase","stop"]
}
}
}
}
},
"mappings": {
"_source" : {
"enabled" : true
},
"_all": {
"enabled": false
},
"user": {
"properties": {
"cityId": {
"type": "long"
},
"country": {
"type": "string",
"index":"not_analysed"
},
"emailId": {
"type": "string",
"index":"not_analysed"
},
"employmentDetail": {
"type": "nested",
"properties": {
"companyName": {
"type": "string",
"index":"not_analysed"
},
"designation": {
"type": "string",
"index":"not_analysed"
},
"durationEndMonth": {
"type": "long"
},
"durationEndYear": {
"type": "long"
},
"durationStartMonth": {
"type": "long"
},
"jobProfile": {
"type": "string"
},
"location": {
"type": "string",
"index":"not_analysed"
}
}
},
"examscores": {
"type": "nested",
"properties": {
"attemptedCount": {
"type": "long",
"store" : "yes"
},
"candidateId": {
"type": "long",
"store" : "yes"
},
"examDate": {
"type": "date",
"format": "strict_date_optional_time||epoch_millis"
},
"examId": {
"type": "long",
"store" : "yes"
},
"examScoreDetailId": {
"type": "long"
},
"examTotalScore": {
"type": "double",
"store" : "yes"
},
"examType": {
"type": "long"
},
"katExamEventId": {
"type": "long",
"store" : "yes"
},
"rightAttempted": {
"type": "long"
},
"scorePercent": {
"type": "double",
"store" : "yes"
},
"totalScore": {
"type": "double"
}
}
},
"firstName": {
"type": "string"
},
"projectdetail": {
"type": "nested",
"properties": {
"clientName": {
"type": "string",
"index":"not_analysed"
},
"designation": {
"type": "string",
"index":"not_analysed"
}
},
"id": {
"type": "long"
},
"location": {
"type": "string",
"index":"not_analysed"
},
"title": {
"type": "string"
},
"userId": {
"type": "long"
}
}
},
"qualification": {
"type": "nested",
"properties": {
"id": {
"type": "long"
},
"institute": {
"type": "string",
"index":"not_analysed"
},
"isPrimary": {
"type": "long"
},
"passingYear": {
"type": "long"
}
}
},
"stateId": {
"type": "long"
},
"userId": {
"type": "long",
"store" : "yes"
},
"uuid": {
"type": "string",
"store" : "yes",
"index":"not_analysed"
} }
}
}
}
}
}