更新时间:2022-08-22 14:24:14
Jdbc input plugin 配置选项
Setting |
Input type |
Required |
Default |
clean_run |
boolean |
No |
false |
columns_charset |
hash |
No |
{} |
connection_retry_attempts |
number |
No |
1 |
connection_retry_attempts_wait_time |
number |
No |
0.5 |
jdbc_connection_string |
string |
Yes |
- |
jdbc_default_timezone |
string |
No |
- |
jdbc_driver_class |
string |
Yes |
- |
jdbc_driver_library |
string |
No |
- |
jdbc_fetch_size |
number |
No |
- |
jdbc_page_size |
number |
No |
100000 |
jdbc_paging_enabled |
boolean |
No |
false |
jdbc_password |
password |
No |
- |
jdbc_password_filepath |
string |
No |
- |
jdbc_pool_timeout |
number |
No |
5 |
jdbc_user |
string |
Yes |
- |
jdbc_validate_connection |
boolean |
No |
false |
jdbc_validation_timeout |
number |
No |
3600 |
last_run_metadata_path |
string |
No |
“$HOME/.logstash_jdbc_last_run” |
lowercase_column_names |
boolean |
No |
true |
parameters |
hash |
No |
{} |
plugin_timezone |
string, one of [“local”, “utc”] |
No |
“utc” |
prepared_statement_bind_values |
array |
No |
[] |
prepared_statement_name |
string |
No |
“” |
record_last_run |
boolean |
No |
true |
schedule |
string |
No |
- |
sql_log_level |
string, one of [“fatal”, “error”, “warn”, “info”, “debug”] |
No |
“info” |
statement |
string |
No |
- |
statement_filepath |
string |
No |
- |
tracking_column |
string |
No |
- |
tracking_column_type |
string, one of [“numeric”, “timestamp”] |
No |
“numeric” |
use_column_value |
boolean |
No |
false |
use_prepared_statements |
boolean |
No |
false |
配置文档
https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html
配置示例