I have problem to search the value in Kibana for field I Created mapping keyword and inserted number inside (see example below)
"B_ASSOCIAID": { "type" : "keyword"}
"B_ASSOCIAID" : 5947737601889008123,
in this case Kibana shows
2020-10-14 08:09:45 5947737601889008000
In Kibana search users do not know the real value is 5947737601889008123 and they try to filter the values they see 5947737601889008000 which does not return any results.
please do you have any advice?
It the only solution to fix ingest and store the value with ""?
Thank you
PUT /test_simik_03
{
"mappings" : {
"properties" : {
"@timestamp" : {
"type" : "date",
"format" : "yyyy-MM-dd HH:mm:ss.SSS"},
"B_ASSOCIAID": {
"type" : "keyword"
}
}
}
}
POST test_simik_03/_doc
{
"B_ASSOCIAID" : 5947737601889008123,
"@timestamp" : "2020-10-14 06:09:45.652"
}
GET test_simik_03/_search