Large numbers in kibana as keyword not searchable

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.