Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

VerificationException: Different mappings are not allowed for the same field even if field is not used in query #1171

Open
gauravgk78 opened this issue Jun 21, 2022 · 0 comments

Comments

@gauravgk78
Copy link

gauravgk78 commented Jun 21, 2022

I'm doing a query, but the error response I get is complaining about another field I'm not selecting.
SELECT answer AS answer FROM
(SELECT answer
FROM indexname) AS virtual_table

E.g.

Error: com.amazon.opendistroforelasticsearch.sql.rewriter.matchtoterm.VerificationException: Different mappings are not allowed for the same field[surveyId]: found [{type:text,fields:{keyword:{type:keyword,ignore_above:256}}}] and [{type:keyword}] For more details, please send request for Json format to see the raw response from elasticsearch engine.', 'type': 'VerificationException'}, 'status': 400}

but my query doesn't have surveyId ?Shouldn't elastic just ignore that field completely if it's not used in the select query?
#348 (comment) It's similar to this issue.

@gauravgk78 gauravgk78 changed the title VerificationException: Getting different mappings are not allowed for the same field even field is not used VerificationException: Different mappings are not allowed for the same field even if field is not used in query Jun 21, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant