我认为最好的选择是使用Logstash，并使用JDBC作为输出。例如：

input {
  elasticsearch {
    hosts => "https://localhost:9200/"
    user => "yourUser"
    password => "yourPassword"
    index => "yourIndex"
    query => '{"query":{"match_all": {}}}'
    scroll => "5m"
    size => "5000"
  }
}

output {
  jdbc {
    jdbc_connection_string => ""
    jdbc_user => ""
    jdbc_password => ""
    jdbc_validate_connection => true
    jdbc_driver_library => ""
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
    statement => "INSERT INTO table_name VALUES (value1, value2, value3, ... <<<<< JUST A QUERY EXAMPLE)"
  }
}