On Fri, Feb 11, 2022 at 06:51:34PM +0800, Wu Fengguang wrote:

On Thu, Feb 10, 2022 at 09:25:37PM +0800, Wei Jihui wrote:

...

From: Wei Jihui weijihuiall@163.com

1. /data_api/es/:index/_search is es search by dsl

...

2. /data_api/es/:index/_search_by_sql is es search by sql

建议用 /data_api/_opendistro/_sql

但是现在用的不是这个接口，用的是https://github.com/NLPchina/elasticsearch-sql

Thanks, Jihui

:index 有可能数据重复，此时不可信。

因为真正起作用的是 select 语句里的from， 必需解析后得到index，再基于它做认证。

Thanks, Fengguang