How to use Elasticsearch SQL { XPACK } in Logstash

Hello

I am using Logstash 7.8.0 with Elasticsearch v7.8.0.

I am using Logstash to extract data from ES Index-1 and inserting into ES Index-2.

I am not finding a way to use Elasticsearch SQL a part of xpack into Logstash input plugin of elasticsearch.

Could you please help me in this.

Note: I have certain conditions and grok filter is required to split data into respective fields in Index-2 hence I am using logstash.

Thanks
Tushar Nemade

Hi,

If you have a platinum license you can use the jdbc input plugin of LogStash instead.

Another idea would be to use the http_poller plugin and the SQL REST API

Best regards
Wolfram

Hi

I do not have Platinum license. Have Basic License.

Can i use these he http_poller plugin and the SQL REST API , with BASIC license.

Thanks
Tushar Nemade

What i want is : How to specify

"query": "SELECT * FROM library where timestamp > somedate"

in logstash input plugin of elasticsearch

Thanks
Tushar Nemade

The Elasticsearch SQL-APIs are part of the Basic license

Okay .. Thanks for your response ..

How to specify

"query": "SELECT * FROM library where timestamp > somedate"

in logstash input plugin of elasticsearch

Please have a look here which had a similar request: Logstash http_poller POST Syntax

Okay , Thanks. I will check and update in here...

Thanks
Tushar Nemade