Skip to content

SQL XPack complaining about same index behind an alias with having different mappings. #31611

@ahazelwood

Description

@ahazelwood

Elasticsearch version (bin/elasticsearch --version): 6.3.0, Build: default/deb/424e937/2018-06-11T23:38:03.357887Z, JVM: 1.8.0_171

Plugins installed: []
JVM version (java -version):"1.8.0_171

OS version (uname -a if on a Unix-like system): 4.4.0-128-generic

I am attempting to issue a select statement against a alias and receiving a message about the same index having a different mapping.

Query: { "query": "SELECT * FROM news_current", "fetch_size": 5 }

Response: { "error": { "root_cause": [ { "type": "verification_exception", "reason": "Found 1 problem(s)\nline 1:15: [news_current] points to indices [news-20180614] and [news-20180614] which have different mappings. When using multiple indices, the mappings must be identical." } ], "type": "verification_exception", "reason": "Found 1 problem(s)\nline 1:15: [news_current] points to indices [news-20180614] and [news-20180614] which have different mappings. When using multiple indices, the mappings must be identical." }, "status": 400 }

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions