Logstash not able to output to ES error occurred sending bulk request

[Divit_Sharma]

I am able to see the output in stout but when I am indexing to ES it gives this error

The thing is if I am connecting to Hive from jdbc input this error comes. I am able to index data from oracle.

An error occurred sending a bulk request to elasticsearch. We will retry indefinitely. :error_message=> no method 'setHeaders' for arguments on Java:orgapachehttpclientmethod::httppost\n available overload:\n :error_class:nameerror

However I am able to stout events from Hive no error there

[Divit_Sharma]

Not sure why this is happening I am able to output hive's data in many output like stout, csv, email. Everything works expect elasticsearch output. Why?

Moreover I am able to output to ES from various input sources like csv, oracle etc

@magnusbaeck Can you assist.

[Divit_Sharma]

+more

[Divit_Sharma]

PLEASE HELP. THIS IS MY CONFIG FILE.

For some reason I think that es output is sending some additional fields to host with some garbage values. Or some additional library is required for in jdbc input .

[balumurari1]

hope this helps you,
Make sure you are giving correct database connection details and then follow below sample example

Synchronize data to es and customize es index structure

use below input code to connect to databse and load data from both the tables, in case of "statement", write join query to retrieve data from both tables, input { jdbc { jdbc_driver_library => "D:/Softwares/logstash-6.4.2/lib/com.mysql.jdbc_5.1.5.jar" jdbc_driver_class => "com.mysql.jdbc.Driver" jdbc_connection_string => "jdbc:mysql://localhost:3306/test" jdbc_user => "root" jdbc_password => "root" statement => "SELECT * FROM sample" jdbc_paging_enabled => "true" jdbc_page_size => "50…

[Divit_Sharma]

I am able to make connection and see data in stdout. Its just that it won't index to ES if source is hive.