You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.
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.
The text was updated successfully, but these errors were encountered:
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 freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
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.
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.
The text was updated successfully, but these errors were encountered: