Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ESQL: a nested field having the same name as a supported one discards the supported field name #117054

Closed
astefan opened this issue Nov 19, 2024 · 1 comment · Fixed by #117201
Assignees
Labels
:Analytics/ES|QL AKA ESQL >bug Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)

Comments

@astefan
Copy link
Contributor

astefan commented Nov 19, 2024

Description

For this mapping

{
    "mappings": {
      "properties": {
        "Responses": {
          "properties": {
            "process": {
              "type": "nested",
              "properties": {
                "pid": {
                  "type": "long"
                }
              }
            }
          }
        },        
        "process": {
          "properties": {
            "parent": {
              "properties": {
                "command_line": {
                  "type": "wildcard",
                  "fields": {
                    "text": {
                      "type": "text"
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
}

and query that is using process.parent.command_line - from test | sort process.parent.command_line or from test | where process.parent.command_line == "test string" results in Unknown column [process.parent.command_line] which is incorrect.

@astefan astefan self-assigned this Nov 19, 2024
@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Nov 19, 2024
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-analytical-engine (Team:Analytics)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
:Analytics/ES|QL AKA ESQL >bug Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)
Projects
None yet
2 participants