Jira (PDB-4578) Order by and Group by don't work together

[Austin Blatt (JIRA)]

Austin Blatt created an issue

PuppetDB / PDB-4578 Order by and Group by don't work together Issue Type: New Feature Assignee: Unassigned Created: 2019/10/31 2:44 PM Priority: Normal Reporter: Austin Blatt This seems to be a result of aggregating functions, like count, creating "projections" that order by doesn't know about because they are not in the query maps defined in the query engine. It is also explicitly disallowed in PQL, you can use only a group by or a paging operator, but not both. In AST, the order by operator seems to nulify the entire extract statement where the group by is. $ curl -X POST http://localhost:8080/pdb/query/v4 -H 'Content-Type:application/json' -d '{"query": [ "from", "events", [ "extract", [ ["function", "count"], "status" ], [ "group_by", "status" ] ] ]}' [{"status":"success","count":1}] and when you add an order by get an error. Add Comment

This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)

[Claudia Petty (Jira)]

Claudia Petty updated an issue

PuppetDB / PDB-4578 Order by and Group by don't work together

Change By: Claudia Petty Labels: new-feature

Add Comment

This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8)