search

harbby / presto-connectors

facebook presto connectors
Apache License 2.0
49 stars 22 forks source link

presto elasticsearch6 can show table,but can't query #9

Open foxmoon opened 5 years ago

foxmoon commented 5 years ago

when query elasticsearch6 by presto, Log append error like below: "java.lang.IllegalArgumentException: Multiple entries with same key: _id=ElasticsearchColumnHandle{name=_Id, type=varchar, keyword=true"

show table can work correct. " presto:default> show tables; Table

accompanylogs_index " query can't work . " resto:default> select id from accompanylogs_index; Query is gone (server restarted?) "

log like below. " 2018-12-20T11:56:38.485+0800 WARN statement-response-4 com.facebook.presto.server.ThrowableMapper Request failed for /v1/statement/20181220_035638_00008_c79ve/1 java.lang.IllegalArgumentException: Multiple entries with same key: _id=ElasticsearchColumnHandle{name=_id, type=varchar, keyword=false, comment=, hidden=true} and _id=ElasticsearchColumnHandle{name=_Id, type=varchar, keyword=true, comment=_扩展字段用于match_query, hidden=true} "

harbby commented 5 years ago

Hi @foxmoon: dsl,type,id,score as a built-in reserved field, if they exist in the index they will receive the following error see:https://github.com/harbby/presto-connectors/tree/master/presto-elasticsearch#major