search

preset-io / elasticsearch-dbapi

A DBAPI and SQLAlchemy dialect for Elasticsearch
Apache License 2.0
108 stars 51 forks source link

Elasticsearch version is not supported #96

Closed putianhui closed 1 year ago

putianhui commented 1 year ago

Hello, I use superset to connect the elastic search of 6.8.1, and the following error will be prompted

2022-10-27 06:27:01,034:DEBUG:elasticsearch:> {"query":"SELECT 1"}
2022-10-27 06:27:01,034:DEBUG:elasticsearch:< {"error":"Incorrect HTTP method for uri [/_sql/] and method [POST], allowed: [DELETE, PUT, GET, HEAD]","status":405}

Is there an elastic search version that supports 6.8.1?

dpgaspar commented 1 year ago

Unfortunately no, only 7.X versions are supported

NoGroceries commented 6 months ago

Hello, I use superset to connect the elastic search of 7.10.2, and the following error will be prompted.

curl -X POST http://localhost:9200/_sql -d '{"query": "SELECT 1"}' -H 'Content-Type: application/json' {"error":"Incorrect HTTP method for uri [/_sql] and method [POST], allowed: [PUT, GET, HEAD, DELETE]","status":405}