Jira (PDB-3601) PQL array 'in' operator to match by type or allow sql-like field aliases

[Malcolm Herbert (JIRA)]

Malcolm Herbert created an issue

PuppetDB / PDB-3601 PQL array 'in' operator to match by type or allow sql-like field aliases Issue Type: New Feature Affects Versions: PDB 4.2.3.1 Assignee: Unassigned Components: PuppetDB Created: 2017/06/27 4:47 PM Environment: internal to the PQL parser, affects all platforms Priority: Normal Reporter: Malcolm Herbert PQL query using the array-form 'in' operator as below will fail because the output of the aggregate function min() is a field named 'min', not 'receive_time': reports { [certname, receive_time] in reports [certname, min(receive_time)] { certname ~ "foo" group by certname } } can we either match fields by position in the array (poor), position and type (better) or provide SQL-like aliases in the second array as in: [certname, receive_time] in reports [certname, min(receive_time) as receive_time] Add Comment

This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe)

[Malcolm Herbert (JIRA)]

Malcolm Herbert updated an issue

PuppetDB / PDB-3601 PQL array 'in' operator to match by type or allow sql-like field aliases

Change By: Malcolm Herbert

PQL query using the array-form 'in' operator as below will fail because the output of the aggregate function min() is a field named 'min', not 'receive_time': reports {    [certname, receive_time] in reports [certname, min(receive_time)] {

certname     code_id  ~ "foo ;development "      group     order  by certname

}  } can we either match fields by position in the array (poor), position and type (better) or provide SQL-like aliases in the second array as in: [certname, receive_time] in reports [certname, min(receive_time) as receive_time]

Add Comment

[Malcolm Herbert (JIRA)]

Malcolm Herbert commented on PDB-3601

Re: PQL array 'in' operator to match by type or allow sql-like field aliases refer https://support.puppet.com/hc/en-us/requests/26307 for more background

Add Comment

[Wyatt Alt (JIRA)]

Wyatt Alt commented on PDB-3601

Re: PQL array 'in' operator to match by type or allow sql-like field aliases

aliases + allowing incorporation of function results in queries is a good feature I think. For this specific case though is the objective to get the earliest receive time for each certname? If that's the case I think you can do reports[certname, min(receive_time)]{code_id ~ "foo;development" group by certname} ordering on top of that is currently broken due to an issue related to PDB-3591 I believe but the results should at least be right.

Add Comment

[Claudia Petty (Jira)]

Claudia Petty updated an issue

PuppetDB / PDB-3601

PQL array 'in' operator to match by type or allow sql-like field aliases

Change By: Claudia Petty Labels: new-feature

Add Comment

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