SQL Queries

Elastic Stack Elasticsearch
1

Hi,

SELECT * FROM index where index.id NOT IN ( SELECT index.responseID from index where index.type=3)

i am writing this sql in elastic search but it says "not in query not supported yet". I'm wondering can i write this query in elastic DSL? or can i write this query another way ?

2

That is basically a join, which is not supported by Elasticsearch.

3

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