Send every 10th sample to another index

[Marcus_Monnig (Marcus Mönnig)]

Hi!

I have a setup like this:

input {
    jdbc {
        jdbc_validate_connection => false
        jdbc_connection_string => "jdbc:oracle:thin:@HOST:1521/SID"
        jdbc_user => "..."
        jdbc_password => "..."
        jdbc_driver_library => "/opt/ojdbc7.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
        statement => "select ..."
        schedule => "*/6 * * * * *"
       }
}
output   {
    elasticsearch {index => "orcldata-%{+YYYY.MM.dd}" }
}

This executes the select query every 6 seconds and sends it to the specifies index.

Now, I want to addtionally send the data from every 10th scheduled run to another index. Is there a way to do this without using another import section with a different schedule?

Thanks for your help!
Marcus