Using SQLServer to query elasticSearch data
<p>In my use case, ElasticSearch is already configured and has data that can be queried via REST API. I'm wondering if there is a way to write SQL statements that can query this data that ElasticSearch is already configured on. </p>

<p>Example, configure an adapter to ElasticSearch in MS SQLServer and use linkedserver to connect and run normal SQL statements.</p>

<p>I have read about the "river", but it seems to do the opposite of what I'm looking for. Any pointers will really help.</p>