# Jdbc-input-plugin can handle limited number of sql fields

**URL:** <https://discuss.elastic.co/t/jdbc-input-plugin-can-handle-limited-number-of-sql-fields/103092>\
**Category:** Logstash\
**Created:** [October 6, 2017, 11:44pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-can-handle-limited-number-of-sql-fields/103092 "2017-10-06T23:44:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![enrico\_villa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/enrico_villa/32/78353_2.png) [@enrico\_villa](https://discuss.elastic.co/u/enrico_villa)\
**Post date:** [October 6, 2017, 11:44pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-can-handle-limited-number-of-sql-fields/103092/1 "2017-10-06T23:44:07Z")

</div>

Hi There,  
I'm importing to ES from mysql , via logstash (latest) and jdbc-input, a 200 fields table

logstash (ran via command line using -f) was existing without any error so I activated mysql logging and verified the query is acually sent to the database.

then I tried only 50 columns and everything was ok.

Is there any known limitation on number of fields specified by the query ?

thanks!

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [October 7, 2017, 7:50am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-can-handle-limited-number-of-sql-fields/103092/2 "2017-10-07T07:50:00Z")

</div>

I looked at the plugin code - I can't see any limits.

We use a 3rd party library called Sequel which has JDBC abstractions.  
This code does call methods like `createStatement` and `executeOuery` which, because of their names, indicate that they are direct to Java calls - to the JDBC driver.

However, I can't find any links on the web showing a limit in JDBC itself or the mysql jdbc driver.

Please verify, in your mysql logging, whether any other queries are sent to the db before the query you gave to the jdbc input. Maybe queries to the table schema etc.

If I get time I can troubleshoot further but I need to know the DB and driver versions too.

---

<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:** [November 4, 2017, 7:50am UTC](https://discuss.elastic.co/t/jdbc-input-plugin-can-handle-limited-number-of-sql-fields/103092/3 "2017-11-04T07:50:22Z")

</div>

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