Create a view mysql with logstash

[MatteoM (Matteo Marulli)]

Hi there!,
I was wondering if exists a way to create a view mysql through by the statement in the pipeline input jdbc.
I need to create some views because these are involved in a query that I need it to save in a index in elasticsearch.

PS: one last thing if I have more then one mysql tables how can i make more one index for table ?
Let me be clear, I have 3 tables: tableA, tableB, tableC and I want to save these in elasticsearch like tableA-index, tableB-index, tableC-index.
if I understand correctly I have to create a pipeline output like this, right?
output {

  stdout { codec => json_lines }
  elasticsearch {
    hosts => "elasticsearch:9200"
    index => "tableA-index"
  }

  stdout { codec => json_lines }
  elasticsearch {
    hosts => "elasticsearch:9200"
    index => "tableB-index"
  }

  stdout { codec => json_lines }
  elasticsearch {
    hosts => "elasticsearch:9200"
    index => "tableC-index"
  }
}