# Jdbc\_static lookups returns more than one row

**URL:** <https://discuss.elastic.co/t/jdbc-static-lookups-returns-more-than-one-row/173724>\
**Category:** Logstash\
**Created:** [March 25, 2019, 10:32am UTC](https://discuss.elastic.co/t/jdbc-static-lookups-returns-more-than-one-row/173724 "2019-03-25T10:32:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaire](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaire/32/38866_2.png) [@chaire](https://discuss.elastic.co/u/chaire)\
**Post date:** [March 25, 2019, 10:32am UTC](https://discuss.elastic.co/t/jdbc-static-lookups-returns-more-than-one-row/173724/1 "2019-03-25T10:32:31Z")

</div>

I'm using jdbc\_static filter to enrich data from another log. My problem is that my lookups returns more than one row. When I tried accessing the field with something like "%{[server][0][description]}" it didn't get the wanted value.  
I know that it is stated in Logstash documentation that "Ideally the SQL statement should only return one row." But what should be the solution if this kind of problem happens?  
Thank you for your guidance.

---

<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:** [April 22, 2019, 10:32am UTC](https://discuss.elastic.co/t/jdbc-static-lookups-returns-more-than-one-row/173724/2 "2019-04-22T10:32:32Z")

</div>

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