我想添加我的CSV文件到PostgreSQL。但每当我尝试连接它显示错误：[错误][logstash. output. jdbc] jdbc的未知设置"driver_library"，它是我的配置. conf文件
input {
file {
path => "C:/Users/Desktop/Input.csv"
start_position => "beginning"
codec => plain
}
}
filter {
csv {
separator => ","
columns => ["Column","Metric","Source_Table","Output_Column_Alias","Method"]
}
}
output {
jdbc {
connection_string => "jdbc:postgresql://hostname:5432/Database"
username => "User"
password => "Password"
driver_library => "C:/Users/lib/postgresql-42.5.1.jar"
driver_class => "org.postgresql.Driver"
statement => "INSERT INTO CSV_to_Postgresql (Column,Metric,Source_Table,Output_Column_Alias,Method) VALUES (?, ?, ?, ?, ?)"
}
}```
1条答案
按热度按时间kognpnkq1#
使用driver_jar_path，而不是driver_library。弹性支持的插件使用jdbc_driver_library作为此选项的名称，但jdbc输出是使用不同约定的第三方支持的插件。