Module xm_csv - FieldTypes Decimal Numbers

#1 ssoliveira 7 years ago

Hello,

I'm using NXLOG to send data from CSV files to Elasticsearch.

It's working correctly; Other numbers with decimals are being sent as Strings.

What FieldType should I use to work with numbers with decimal places (such as: decimal, double, float)?

Thank you.

<Extension ExtData>
     Module xm_csv
     Fields $Time,$Id,$Budget,$Tax
     FieldTypes string,integer,DECIMAL,DOUBLE
     Delimiter ','
</Extension>

Permalink

#2 b0ti Nxlog ✓ 7 years ago

#1 ssoliveira

Hello, I'm using NXLOG to send data from CSV files to Elasticsearch. It's working correctly; Other numbers with decimals are being sent as Strings. What FieldType should I use to work with numbers with decimal places (such as: decimal, double, float)? Thank you. <Extension ExtData> Module xm_csv Fields $Time,$Id,$Budget,$Tax FieldTypes string,integer,DECIMAL,DOUBLE Delimiter ',' </Extension>

Unfortunately float/double type is not yet supported so it can be only stored as a string.

Perhaps you could try using QuoteMethod None to avoid the quotes?