Skip to content

**SQLBot version** #2

@MVB388

Description

@MVB388

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 不断完善,越来越好!

Originally posted by @huhuhuhr-1 in dataease/SQLBot#108

Originally posted by @MVB388 in #1

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions