JDBC Input Plugin - JOIN Query issue


#1

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


(Magnus Bäck) #2

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.


#3

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.


#4

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%';


(Magnus Bäck) #5

I repeat: What does your configuration look like?


(system) #6

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