# Multiple Select queries in Logstash JDBC Plugin

**URL:** <https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329>\
**Category:** Logstash\
**Created:** [February 21, 2016, 11:33am UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329 "2016-02-21T11:33:33Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![sumit\_gupta\_sgt](https://avatars.discourse-cdn.com/v4/letter/s/dec6dc/32.png) [@sumit\_gupta\_sgt](https://discuss.elastic.co/u/sumit_gupta_sgt)\
**Post date:** [February 21, 2016, 11:33am UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329/1 "2016-02-21T11:33:33Z")

</div>

Hi All,

I am trying to pull data from MYSQL.I am able to get Data from MYSQL.  
But i want fetch data one mysql table as one type in ES index like for Example:

I have A,B, C tables in MYSQL i want to run Select \* on all tables and A as type atype, B as a btype and c as a ctype in ES index.

So final output in ES should be one index with 3 types.I am able to fetch individually but i want all this in one shot in logstash config.

Thanks,  
Sumit

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 21, 2016, 8:12pm UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329/2 "2016-02-21T20:12:21Z")

</div>

Are they similar kinds of data? Cause you need to be really careful using multiple types in ES.

---

<div class="post-metadata">

**Author:** ![sumit\_gupta\_sgt](https://avatars.discourse-cdn.com/v4/letter/s/dec6dc/32.png) [@sumit\_gupta\_sgt](https://discuss.elastic.co/u/sumit_gupta_sgt)\
**Post date:** [February 22, 2016, 5:01am UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329/3 "2016-02-22T05:01:02Z")

</div>

Data is similar but some tables having 10 column and some having 20 column.  
I am not able to see any document for me it seems very common scenario.

Thanks,  
Sumit

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 22, 2016, 5:08pm UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329/4 "2016-02-22T17:08:19Z")

</div>

You are better of putting them in different indices.

---

<div class="post-metadata">

**Author:** ![theuntergeek](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/theuntergeek/32/44961_2.png) [@theuntergeek](https://discuss.elastic.co/u/theuntergeek)\
**Post date:** [February 22, 2016, 6:46pm UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329/5 "2016-02-22T18:46:10Z")

</div>

With this, are you doing a join?

---

<div class="post-metadata">

**Author:** ![sumit\_gupta\_sgt](https://avatars.discourse-cdn.com/v4/letter/s/dec6dc/32.png) [@sumit\_gupta\_sgt](https://discuss.elastic.co/u/sumit_gupta_sgt)\
**Post date:** [February 23, 2016, 5:16am UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329/6 "2016-02-23T05:16:11Z")

</div>

Any Specific Reason?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 5:10am UTC](https://discuss.elastic.co/t/multiple-select-queries-in-logstash-jdbc-plugin/42329/7 "2017-07-06T05:10:10Z")

</div>