Improvement: Select by id should be as fast as query by id

matthewfranglen / postgres-elasticsearch-fdw

Postgres to Elastic Search Foreign Data Wrapper

MIT License

108 stars 32 forks source link

Improvement: Select by id should be as fast as query by id #27

Open matthewfranglen opened 3 years ago

matthewfranglen commented 3 years ago

Originally reported in https://github.com/matthewfranglen/postgres-elasticsearch-fdw/issues/22

Saketha016 commented 3 years ago

Hello,

Need some suggestion on how to handle "aggregation" using DSL search. When I tried with the below query, it returns 400 error.

postgres=# select "@timestamp" from articles_es9 where query = '{"aggs": {"distinct_name_count": {"extended_stats": {"field": "audit_format_version"}}}}';
ERROR:  COUNT for /security-auditlog-2021.04.15 failed: RequestError(400, 'parsing_exception', 'request does not support [aggs]')

Appreciate your help !!