如何在logstash的配置文件里边删除csv中columns中多余的field字段
来源:互联网 发布:中国淘宝十大女模特 编辑:程序博客网 时间:2024/06/07 00:23
当采集数据时生成的csv的文件,但是发现采集表数据有些在es中不需要,这时,可以在filter插件中的csv中,使用remove_field => [ "filed1","filed2" ]来删除多余字段
input {
file {
path => [
"/test/111.csv"
]
start_position => "beginning" #从什么位置读取,beginnig时导入原有数据
sincedb_path => "/test/111"
type => "111"
tags => ["optical", "gather"]
}
}
filter {
if [type] == "111" { #多个配置文件同时执行的区分
csv {
columns =>["gathertime","device_id","oltip","devicename","vendor_id","oltportinfo","oltsendpower","oltrecvpower","onuid","onuip","onusn","onumac","loid","onusendpower","onurecvpower","oltsenddecay","onusenddecay","oltcurrent","olttemperature","oltvoltage","onucurrent","onutemperature","onuvoltage","onuadminstate","onuoperstat","oltadminstate","oltoperstat","distance","oltopvarname","oltopvarpn","oltopvarsn","opticaltype","down_access","up_access","all_access","stat_num","only_id","city_id","branch_id","branch_name","area_type"]
separator => "^"
quote_char => "‰"
remove_field => ["device_id","branch_id","area_type"]
}
}
output{
}
2、使用命令执行logstash
logstash -f 111.conf
3、使用下边命令从es中查询已删除的字段是否存在
curl -XGET 'localhost:9200/gather-111/_search?pretty' -H 'Content-Type:application/json' -d'
{
"query":{
"match":{
"only_id":"19011111"
}
}
}'
"device_id":"190574"
"branch_id":"1759"
"city_id":"118214"
"area_typ":"2"
- 如何在logstash的配置文件里边删除csv中columns中多余的field字段
- 如何删除字符串中多余的空格
- 删除Xcode配置文件 Xcode中多余的证书provisioning profile
- logstash 中input插件读取的数据没有日期,现在想在filter插件的csv插件中插入以时间字段
- MFC中如何删除工具栏中多余的图标
- 如何删除ubuntu中多余的内核镜像
- 如何删除Ubuntu右键中多余的打开方式
- word中如何删除换行符(多余的回车)
- 如何删除Word 2003中多余的Adobe PDF菜单
- 【原创】如何删除明细库中多余的数…
- 如何删除Xcode中多余的证书provisioning profile
- 如何删除ubuntu中多余的PATH变量值
- xcode 删除多余的配置文件
- 如何删除dede中自定义的字段
- sql 删除表中多余的重复记录(多个字段),只保留一条记录
- sql 删除表中多余的重复记录(多个字段),只保留一条记录
- sql 删除表中多余的重复记录(多个字段),只保留一条记录
- Sql删除表中多余的重复记录,保证重复字段唯一
- linux之文本操作命令
- 解决Android 打包后 so文件不完整导致程序崩溃
- A
- Centos5.4安装Virtualbox
- 命运
- 如何在logstash的配置文件里边删除csv中columns中多余的field字段
- Activity或是Fragment中下拉刷新,上推加载的Adapter这样写
- PHP正则表达式中的元字符的功能详细介绍
- 筛法
- [LeetCode] 560. Subarray Sum Equals K
- 学习网址总结
- Spring+SpringMvc+Hibernate项目
- 搭建Git服务器详解
- UE4 RPC在C++中的使用简例