Skip to content

ES|QL query produces column with empty name and null value #125870

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

Closed
luigidellaquila opened this issue Mar 28, 2025 · 1 comment · Fixed by #127499
Closed

ES|QL query produces column with empty name and null value #125870

luigidellaquila opened this issue Mar 28, 2025 · 1 comment · Fixed by #127499
Labels
:Analytics/ES|QL AKA ESQL >bug Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)

Comments

@luigidellaquila
Copy link
Contributor

With test dataset

POST /_query
{
  "query":"from employees | stats  foo = min(emp_no), bar = count_distinct(emp_no) | rename bar AS bug_here, foo AS baz, baz AS bug_here | eval bug_here = \"something\""
}
{
    "took": 5,
    "is_partial": false,
    "columns": [
        {
            "name": "",                  <<<-----
            "type": "null"               <<<-----
        },
        {
            "name": "bug_here",
            "type": "keyword"
        }
    ],
    "values": [
        [
            null,
            "something"
        ]
    ]
}
@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Mar 28, 2025
@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
Development

Successfully merging a pull request may close this issue.

2 participants