-
Notifications
You must be signed in to change notification settings - Fork 344
Closed
Description
SQLBot version
v1.0.0
Please describe your requirements or suggestions for improvement
Elasticsearch 是业界非常常用的检索与分析引擎,使用场景和使用率都非常高。
从 Elasticsearch 6.3 开始,官方就提供了 SQL Translate API,能够将标准 SQL 自动转换为等价的 Query DSL,这是 Elasticsearch 的核心能力之一。
例如:
import requests, json
es = "http://localhost:9200"
sql = """
SELECT category, COUNT(*) AS cnt
FROM products
WHERE price BETWEEN 10 AND 99 AND name LIKE '%shoe%'
GROUP BY category
ORDER BY cnt DESC
LIMIT 5
"""
r = requests.post(f"{es}/_sql/translate", json={"query": sql})
print(json.dumps(r.json(), indent=2, ensure_ascii=False))
因此,希望 SQLBot 能够原生支持 Elasticsearch 智能问数,让用户可以更加便捷地通过自然语言对 Elasticsearch 数据进行交互式分析。
期待 SQLBot 不断完善,越来越好!