ElasticSearch 7.0 doc_type issue

[denishpatel]

When i try to use ES extension, I'm getting this error on Elastic Search 7.0.0. ...

postgres=# Drop fOREIGN TABLE public.test_es;
DEBUG: relation "public.test_es" does not exist
ERROR: foreign table "test_es" does not exist
postgres=# CREATE FOREIGN TABLE public.test_es (
postgres(# col1 int,
postgres(# col2 text,
postgres(# source text
postgres(# ) server umms_elastic OPTIONS (
postgres(# index 'test',
postgres(# doc_type '_doc',
postgres(# column_name_translation 'true'
postgres(# );
LOG: duration: 3.371 ms statement: CREATE FOREIGN TABLE public.test_es (
col1 int,
col2 text,
source text
) server umms_elastic OPTIONS (
index 'test',
doc_type '_doc',
column_name_translation 'true'
);
CREATE FOREIGN TABLE
postgres=# select * from public.test_es;
ERROR: Error in python: TypeError
DETAIL: search() got an unexpected keyword argument 'doc_type'

@rtkrruvinskiy Can you help?

[denishpatel]

Verified that I installed correct version of elasticsearch client

pip list|grep elasticsearch
elasticsearch (7.0.0)

[murphyke]

@denishpatel The compatibility of this FDW is with 1.7 (i.e. ancient history), not 7. There are various things that aren't going to work. If you find an Elasticsearch FDW that has been kept reasonably up to date, let me know!