elasticsearch-dbapi
elasticsearch-dbapi copied to clipboard
preset-io
A DBAPI and SQLAlchemy dialect for Elasticsearch
I am trying to connect to my Elasticsearch cluster on Elastic Cloud, but I keep getting the above error. This is the entire stack trace, ``` --------------------------------------------------------------------------- gaierror Traceback (most...
Our Elastic cluster has a number of indexes that don't return this value. The indexes do appear to be empty as well from looking at the indexes in elastic. This...
Hello, I tried to use datastream in Superset to create data a dataset, but Superset doesn't see datastreams created using elasticsearch rest api as a table (screenshot attached) so I...
https://github.com/preset-io/elasticsearch-dbapi/blob/7e48e57367c3b745bc640fc84d4aca4833a099ed/README.md?plain=1#L110 The »Fetch size« section of the README reads like the module does not automatically / on request use https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-pagination.html to retrieve all results and neither seems to issue a...
It is not clear to me how to query an endpoint that uses HTTP Basic Authentication. I tried ``` engine = create_engine( "elasticsearch+https://.../", connect_args={"password": credentials.password, "user": credentials.login}, ) ``` but...
https://github.com/preset-io/elasticsearch-dbapi/blob/0d5a93058fc82071169f199bfae85d7b5162a12a/es/baseapi.py#L318 needs to pass a `content-type: application/json` header, otherwise no requests go through, using ``` elastic-transport==8.0.1 elasticsearch==8.0.1 elasticsearch-dbapi==0.2.2 SQLAlchemy==1.4.32 ```
Currently, the project has support only for geo_point. It would be great to support also the [geo_shape](https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-shape.html) type. I would like to have a PR for that if you want....
Hello preset-io team, I am facing some issues with using elasticsearch-dbapi version: 0.2.6. I have described the issue in detail in the apache superset project too. [SuperSet errors with AWS...
Index with nested columns throwing errors while exporting as Table Visualization. The data is shown correctly in SQL Lab. :POST http://localhost:9200/_opendistro/_sql/?format=csv [status:N/A request:10.012s] Traceback (most recent call last): File "/usr/local/AT_Dev_Env/AmritaTech/apache-superset/master/incubator-superset/venv/lib/python3.6/site-packages/urllib3/connectionpool.py",...
