I have an xlsx file that I convert in CSV file using ssconvert tool. In the new generated file, there's one field in floating point type. But after ingestion, the values taken from the file is no more in float.
For exemple: This value 99,8923 become "99,8923" in the generated file but other values in the same field are correctly parsed, like 54 is 54.
I suspect that the probleme may come from " added around the number. After ingesting this number with Logstash, it becomes 998923 even if I specify in logstash that it is a float and I can see clearly that the field is typed with float in Kibana.
Here is the version I'm currently using: Elasticsearch : 8.3 Kibana : 8.3 Operating Sys : Red Hat Enterprise Linux 8.5 (Ootpa)
Also make sure you create a mapping ahead of time for that type
float:
integers are converted to floats
strings are parsed; comma-separators and dot-decimals are supported (e.g., "1,000.5" produces a float with value of one thousand and one half)
boolean true and boolean false are converted to 1.0 and 0.0 respectively
float_eu:
same as float, except string values support dot-separators and comma-decimals (e.g., "1.000,5" produces a float with value of one thousand and one half)
I really appreciate your help and it's working. Sometimes, I feel like "Why I didn't see that" ... That's why the community is around , so your help was a light...
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.