Sink the output of an SQL Query back into an index in Elasticsearch


Is it possible to write the output data of an SQL query result back into a new index in Elasticsearch?

My use case
I have two indices in our Elasticsearch cluster and have to perform JOIN operations to denormalize it but after that I want to write the output to a new index to query it later. Is the sinking possible? Something on the lines of how you can write the output of a KSQL query on Kafka Streams back into a new topic in Kafka.

Not directly. You could do it with Logstash and the Elasticsearch input and output.

1 Like

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