Fluentd
1.0
Search
⌃K
Comment on page

csv

The csv parser plugin parses CSV format.

Parameters

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.
Previous
ltsv
Next
tsv
Last modified 2yr ago