# JDBC Input Plugin - JOIN Query issue

**URL:** <https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063>\
**Category:** Logstash\
**Created:** [May 31, 2018, 1:28pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063 "2018-05-31T13:28:46Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ysumit](https://avatars.discourse-cdn.com/v4/letter/y/4da419/32.png) [@ysumit](https://discuss.elastic.co/u/ysumit)\
**Post date:** [May 31, 2018, 1:28pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063/1 "2018-05-31T13:28:46Z")

</div>

Hi Team

I am unable to receive any input when I am using an INNER JOIN query in jdbc input plugin of  
Logstash.

Need immediate assistance.

Sumit

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [May 31, 2018, 1:49pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063/2 "2018-05-31T13:49:11Z")

</div>

> I am unable to receive any input when I am using an INNER JOIN query in jdbc input plugin of  
> Logstash.

It's impossible to help without details. What does your configuration look like? Have you looked in the Logstash log for clues?

> Need immediate assistance.

If you need immediate assistance perhaps you shouldn't rely on a volunteer forum like this one.

---

<div class="post-metadata">

**Author:** ![ysumit](https://avatars.discourse-cdn.com/v4/letter/y/4da419/32.png) [@ysumit](https://discuss.elastic.co/u/ysumit)\
**Post date:** [May 31, 2018, 1:55pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063/3 "2018-05-31T13:55:28Z")

</div>

It does not throw error in logstash plainlog file:

line.batch.delay"=\>50}  
[2018-05-31T19:17:28,894][INFO][logstash.pipeline] Pipeline started successfully {:pipeline\_id=\>"ruei-cc-session", :thread=\>"#\<Thread:0x119ac1ab@/usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:247 run\>"}  
[2018-05-31T19:17:28,903][INFO][logstash.agent] Pipelines running {:count=\>1, :pipelines=\>["ruei-cc-session"]}  
[2018-05-31T19:18:00,979][INFO][logstash.inputs.jdbc] (0.059484s) select \* from Concurrent\_session  
[2018-05-31T19:19:00,132][INFO][logstash.inputs.jdbc] (0.003427s) select \* from Concurrent\_session  
[2018-05-31T19:20:00,160][INFO][logstash.inputs.jdbc] (0.004180s) select \* from Concurrent\_session  
[2018-05-31T19:21:00,231][INFO][logstash.inputs.jdbc] (0.002410s) select \* from Concurrent\_session  
[2018-05-31T19:22:00,307][INFO][logstash.inputs.jdbc] (0.003243s) select \* from Concurrent\_session

however it is not putting any data in file i had mentioned.

---

<div class="post-metadata">

**Author:** ![ysumit](https://avatars.discourse-cdn.com/v4/letter/y/4da419/32.png) [@ysumit](https://discuss.elastic.co/u/ysumit)\
**Post date:** [May 31, 2018, 1:55pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063/4 "2018-05-31T13:55:58Z")

</div>

Query : select WG\_\_BIDATAKPI\_MASTER.name,WG\_\_BIDATAKPI\_MASTER.CATEGORY,WG\_\_BIDATAKPI\_MASTER.TARGET\_MIN,WG\_\_BIDATAKPI\_MASTER.TARGET\_MAX,WG\_\_BIDATAKPI\_MASTER.VALUE,WG\_\_BIDATAKPI\_MASTER.STATUS,WG\_\_BIDATAKPI\_PERIOD.stamp from WG\_\_BIDATAKPI\_MASTER INNER JOIN WG\_\_BIDATAKPI\_PERIOD ON WG\_\_BIDATAKPI\_MASTER.PERIOD\_ID = WG\_\_BIDATAKPI\_PERIOD.PERIOD\_ID where WG\_\_BIDATAKPI\_PERIOD.stamp \> sysdate - 334/1440 and WG\_\_BIDATAKPI\_MASTER.name like '%Sessio%';

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [May 31, 2018, 2:59pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063/5 "2018-05-31T14:59:38Z")

</div>

I repeat: What does your configuration look like?

---

<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:** [June 28, 2018, 2:59pm UTC](https://discuss.elastic.co/t/jdbc-input-plugin-join-query-issue/134063/6 "2018-06-28T14:59:41Z")

</div>

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