设置	输入类型	必需
`autodetect_column_names`	布尔值	否
`autogenerate_column_names`	布尔值	否
`charset`	字符串，以下之一：["ASCII-8BIT", "UTF-8", "US-ASCII", "Big5", "Big5-HKSCS", "Big5-UAO", "CP949", "Emacs-Mule", "EUC-JP", "EUC-KR", "EUC-TW", "GB2312", "GB18030", "GBK", "ISO-8859-1", "ISO-8859-2", "ISO-8859-3", "ISO-8859-4", "ISO-8859-5", "ISO-8859-6", "ISO-8859-7", "ISO-8859-8", "ISO-8859-9", "ISO-8859-10", "ISO-8859-11", "ISO-8859-13", "ISO-8859-14", "ISO-8859-15", "ISO-8859-16", "KOI8-R", "KOI8-U", "Shift_JIS", "UTF-16BE", "UTF-16LE", "UTF-32BE", "UTF-32LE", "Windows-31J", "Windows-1250", "Windows-1251", "Windows-1252", "IBM437", "IBM737", "IBM775", "CP850", "IBM852", "CP852", "IBM855", "CP855", "IBM857", "IBM860", "IBM861", "IBM862", "IBM863", "IBM864", "IBM865", "IBM866", "IBM869", "Windows-1258", "GB1988", "macCentEuro", "macCroatian", "macCyrillic", "macGreek", "macIceland", "macRoman", "macRomania", "macThai", "macTurkish", "macUkraine", "CP950", "CP951", "IBM037", "stateless-ISO-2022-JP", "eucJP-ms", "CP51932", "EUC-JIS-2004", "GB12345", "ISO-2022-JP", "ISO-2022-JP-2", "CP50220", "CP50221", "Windows-1256", "Windows-1253", "Windows-1255", "Windows-1254", "TIS-620", "Windows-874", "Windows-1257", "MacJapanese", "UTF-7", "UTF8-MAC", "UTF-16", "UTF-32", "UTF8-DoCoMo", "SJIS-DoCoMo", "UTF8-KDDI", "SJIS-KDDI", "ISO-2022-JP-KDDI", "stateless-ISO-2022-JP-KDDI", "UTF8-SoftBank", "SJIS-SoftBank", "BINARY", "CP437", "CP737", "CP775", "IBM850", "CP857", "CP860", "CP861", "CP862", "CP863", "CP864", "CP865", "CP866", "CP869", "CP1258", "Big5-HKSCS:2008", "ebcdic-cp-us", "eucJP", "euc-jp-ms", "EUC-JISX0213", "eucKR", "eucTW", "EUC-CN", "eucCN", "CP936", "ISO2022-JP", "ISO2022-JP2", "ISO8859-1", "ISO8859-2", "ISO8859-3", "ISO8859-4", "ISO8859-5", "ISO8859-6", "CP1256", "ISO8859-7", "CP1253", "ISO8859-8", "CP1255", "ISO8859-9", "CP1254", "ISO8859-10", "ISO8859-11", "CP874", "ISO8859-13", "CP1257", "ISO8859-14", "ISO8859-15", "ISO8859-16", "CP878", "MacJapan", "ASCII", "ANSI_X3.4-1968", "646", "CP65000", "CP65001", "UTF-8-MAC", "UTF-8-HFS", "UCS-2BE", "UCS-4BE", "UCS-4LE", "CP932", "csWindows31J", "SJIS", "PCK", "CP1250", "CP1251", "CP1252", "external", "locale"]	否
`columns`	数组	否
`convert`	哈希	否
`ecs_compatibility`	字符串	否
`include_headers`	布尔值	否
`quote_char`	字符串	否
`separator`	字符串	否
`skip_empty_columns`	布尔值	否
`target`	字符串	否

`autodetect_column_names`

编辑

值类型为布尔值
默认值为false

定义是否应从标题列自动检测列名称。默认为 false。

`autogenerate_column_names`

编辑

值类型为布尔值
默认值为true

定义是否应自动生成列名称。默认为 true。如果设置为 false，则不会解析未指定标题的列。

`charset`

编辑

值可以是以下任何一个：ASCII-8BIT, UTF-8, US-ASCII, Big5, Big5-HKSCS, Big5-UAO, CP949, Emacs-Mule, EUC-JP, EUC-KR, EUC-TW, GB2312, GB18030, GBK, ISO-8859-1, ISO-8859-2, ISO-8859-3, ISO-8859-4, ISO-8859-5, ISO-8859-6, ISO-8859-7, ISO-8859-8, ISO-8859-9, ISO-8859-10, ISO-8859-11, ISO-8859-13, ISO-8859-14, ISO-8859-15, ISO-8859-16, KOI8-R, KOI8-U, Shift_JIS, UTF-16BE, UTF-16LE, UTF-32BE, UTF-32LE, Windows-31J, Windows-1250, Windows-1251, Windows-1252, IBM437, IBM737, IBM775, CP850, IBM852, CP852, IBM855, CP855, IBM857, IBM860, IBM861, IBM862, IBM863, IBM864, IBM865, IBM866, IBM869, Windows-1258, GB1988, macCentEuro, macCroatian, macCyrillic, macGreek, macIceland, macRoman, macRomania, macThai, macTurkish, macUkraine, CP950, CP951, IBM037, stateless-ISO-2022-JP, eucJP-ms, CP51932, EUC-JIS-2004, GB12345, ISO-2022-JP, ISO-2022-JP-2, CP50220, CP50221, Windows-1256, Windows-1253, Windows-1255, Windows-1254, TIS-620, Windows-874, Windows-1257, MacJapanese, UTF-7, UTF8-MAC, UTF-16, UTF-32, UTF8-DoCoMo, SJIS-DoCoMo, UTF8-KDDI, SJIS-KDDI, ISO-2022-JP-KDDI, stateless-ISO-2022-JP-KDDI, UTF8-SoftBank, SJIS-SoftBank, BINARY, CP437, CP737, CP775, IBM850, CP857, CP860, CP861, CP862, CP863, CP864, CP865, CP866, CP869, CP1258, Big5-HKSCS:2008, ebcdic-cp-us, eucJP, euc-jp-ms, EUC-JISX0213, eucKR, eucTW, EUC-CN, eucCN, CP936, ISO2022-JP, ISO2022-JP2, ISO8859-1, ISO8859-2, ISO8859-3, ISO8859-4, ISO8859-5, ISO8859-6, CP1256, ISO8859-7, CP1253, ISO8859-8, CP1255, ISO8859-9, CP1254, ISO8859-10, ISO8859-11, CP874, ISO8859-13, CP1257, ISO8859-14, ISO8859-15, ISO8859-16, CP878, MacJapan, ASCII, ANSI_X3.4-1968, 646, CP65000, CP65001, UTF-8-MAC, UTF-8-HFS, UCS-2BE, UCS-4BE, UCS-4LE, CP932, csWindows31J, SJIS, PCK, CP1250, CP1251, CP1252, external, locale
默认值为"UTF-8"

用于 convert 选项的有效转换类型列表。此编解码器中使用的字符编码。示例包括 "UTF-8" 和 "CP1252"。

`columns`

编辑

值类型为数组
默认值为[]

解码时：定义一个列名称列表（按照它们在 CSV 中出现的顺序，就像它是标题行一样）。如果未配置 columns，或者指定的列不足，则默认列名称为 "column1"、"column2" 等。

编码时：要包含在编码的 CSV 中的字段名称列表，按照列出的顺序。

`convert`

编辑

值类型为哈希
默认值为{}

定义要应用于列的一组数据类型转换。可能的转换是：integer、float、date、date_time、boolean

示例

    filter {
      csv {
        convert => { "column1" => "integer", "column2" => "boolean" }
      }
    }

`ecs_compatibility`

编辑

值类型为字符串
支持的值为
- disabled: 在根级别添加 CSV 数据
- v1, v8: 符合 Elastic Common Schema 的行为（还会添加 [event][original]）
默认值取决于正在运行的 Logstash 版本
- 当 Logstash 提供 pipeline.ecs_compatibility 设置时，其值将用作默认值
- 否则，默认值为 disabled

控制此插件与Elastic Common Schema (ECS)的兼容性。

`include_headers`

编辑

值类型为布尔值
默认值为false

当在输出插件中编码时，在每个编解码器生命周期中包含一次编码的 CSV 中的标头（而不是针对每个事件）。默认值 ⇒ false

`quote_char`

编辑

值类型为字符串
默认值为 "\""

定义用于引用 CSV 字段的字符。如果未指定，则默认值为双引号 "。可选。

`separator`

编辑

值类型为字符串
默认值为 ","

定义列分隔符值。如果未指定，则默认值为逗号 ,。可选。

`skip_empty_columns`

编辑

值类型为布尔值
默认值为false

定义是否应跳过空列。默认为 false。如果设置为 true，则不会包含不包含值的列。

`target`

编辑

值类型为字符串
此设置没有默认值。

定义用于放置行值的目标字段。如果未设置此设置，则 CSV 数据将存储在事件的根（顶层）。

例如，如果您希望数据被放在 document 字段下

    input {
      file {
        codec => csv {
          autodetect_column_names => true
          target => "[document]"
        }
      }
    }

« Collectd 编解码插件 Dots 编解码插件 »

On this page

安装
获取帮助
描述
与 Elastic Common Schema (ECS) 的兼容性
CSV 编解码器配置选项
autodetect_column_names
autogenerate_column_names
charset
columns
convert
ecs_compatibility
include_headers
quote_char
separator
skip_empty_columns
target

Was this helpful?

Feedback

The Search AI Company

Generative AI

Search

Security

Observability

By solution

Industries

CSV 编解码插件