Hello, thank you for your reply.
In fact i raised java heap size to 3g and can't go further.
Otherwise, after doing some search, i found this:
It's so weird that no one talk about this. I tried version 7.0.0 and it works.
Which version did you use ?
This is my config:
input {
jdbc {
jdbc_connection_string => "jdbc:postgresql://${POSTGRES_HOST}:${POSTGRES_PORT}/${DB_NAME}"
jdbc_driver_class => "org.postgresql.Driver"
jdbc_user => "${JDBC_USER}"
jdbc_password => "${JDBC_PASSWORD}"
jdbc_paging_enabled => true
jdbc_page_size => 10000
statement_filepath=> "/usr/share/logstash/config/indexing_sql/decision_indexing.sql"
type => "decision"
}
}
filter {
mutate {
add_field => {
"[my_join_field][name]" => "decision"
"[my_join_field][parent]" => "%{case_id}"
}
}
}
output {
elasticsearch {
hosts => "elasticsearch:9200"
user => "elastic"
password => "changeme"
index => "case"
routing => "%{case_id}"
}
}
Do you have any idea what's missing ?