csv

The csv parser plugin parses CSV format.

Parameters

See Parse Section Configurations.

keys

type

default

version

array of string

required parameter

0.14.9

The array of names for fields on each line.

delimiter

type

default

version

string

,

0.14.2

The delimiter (character or string) separating CSV values.

parser_type

type

default

available values

version

enum

normal

normal/fast

1.7.0

The parser type used to parse the log line.

  • normal uses Ruby's

    CSV.parse_line

    method.

  • fast uses its own lightweight implementation. This parser is several times

    faster than normal but it supports only typical patterns.

Supported CSV formats by fast:

# non-quoted
value1,value2,value3,value4,value5
# quoted
"value1","val,ue2","va,lu,e3","val ue4",""
# escaped
"message","mes""sage","""message""",,""""""
# mixed
message,"mes,sage","me,ssa,ge",mess age,""

If your CSV format is not matched with the above patterns, use normal parser instead.

Example

With this configuration:

<parse>
@type csv
keys time,host,req_id,user
time_key time
</parse>

This incoming event:

2013/02/28 12:00:00,192.168.0.1,111,-

is parsed as:

time:
1362020400 (2013/02/28/ 12:00:00)
record:
{
"host" : "192.168.0.1",
"req_id" : "111",
"user" : "-"
}

If you set null_value_pattern '-' in the configuration, user field becomes nil instead of "-".

If this article is incorrect or outdated, or omits critical information, please let us know. Fluentd is an open-source project under Cloud Native Computing Foundation (CNCF). All components are available under the Apache 2 License.