Bug of /_nlpcn/sql with subqueries

Elastic Stack Elasticsearch
1

After using the /_nlpcn/sql interface to query the sql with subqueries, some subsequent queries will time out.

sql sample:
SELECT count(*) FROM a_index where someCode in (SELECT code FROM b_index where someType ='ttt')

2

This seem related to some third party plugin that is not supported here. I would recommend you bring this up with the creator of the plugin.

1 Like