Can I add a month variable to the table name?

Elastic Stack Logstash
1

Hello.

I want to put a specific variable in the table.

Looking at the topic, it can be solved through statement_filepath.
I am not sure how.

Here is what I want:

${mmm} : jan, feb, mar, apr, may ...., dec

input {
  jdbc {
    jdbc_driver_library => "C:\tools\mysql\connector\mysql-connector-java-5.1.44.jar"
    jdbc_driver_class => "com.mysql.jdbc.Driver"
    jdbc_connection_string => "****"
    jdbc_user => "****"
    jdbc_password => "****"
    jdbc_paging_enabled => true
    tracking_column => "unix_ts_in_secs"
    use_column_value => true
    tracking_column_type => "numeric"
    schedule => "* * * * *"
    statement => "SELECT *, UNIX_TIMESTAMP(update_date) AS unix_ts_in_secs 
        FROM table_${mmm} 
        WHERE (UNIX_TIMESTAMP(update_date) > :sql_last_value AND update_date < NOW()) ORDER BY update_date ASC"
  }
}

Thank you for watching.

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.