Jira (PDB-1441) support nested extracts
Title: Message Title Claudia Petty updated an issue PuppetDB / PDB-1441 support nested extracts Change By: Claudia Petty Labels: new-feature Add Comment This message was sent by Atlassian Jira (v8.20.21#820021-sha1:38274c8) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.76264.1429221635000.2483.1687359481937%40Atlassian.JIRA.
Jira (PDB-1441) support nested extracts
Title: Message Title Wyatt Alt updated an issue PuppetDB / PDB-1441 support nested extracts Change By: Wyatt Alt ifwehadnestedextracts,wecouldreplicatetheexistingfunctionalityofaggregate-event-countsbyusingthegroup-byoperatorwithaquerylikethis:curl-XGEThttp://localhost:8080/v4/events-d'query=[extract,[[function,count],status],[extract,[[function,count],status,containing_class],[~,certname,.*],[group_by,status,containing_class]],[group_by,status]]whichwouldtranslateintosomethinglike:selectstatus,count(1)from(selectstatus,containing_class,count(1)fromresource_eventsgroupbystatus,containing_class)ecgroupbystatusthiswouldbemoreorless equalivalent equivalent toanaggregate-event-countscallwithsummarize_by=containing_class. Add Comment This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d) -- You received this message because you are subscribed to the Google Groups Puppet Bugs group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-1441) support nested extracts
Title: Message Title Wyatt Alt created an issue PuppetDB / PDB-1441 support nested extracts Issue Type: New Feature Assignee: Unassigned Created: 2015/04/16 3:00 PM Priority: Normal Reporter: Wyatt Alt if we had nested extracts, we could replicate the existing functionality of aggregate-event-counts by using the group-by operator with a query like this: curl -X GET http://localhost:8080/v4/events -d 'query=[extract, [[function,count],status], [extract, [[function,count],status, containing_class], [~,certname,.*], [group_by, status, containing_class]], [group_by, status]] which would translate into something like: select status,count(1) from (select status,containing_class,count(1) from resource_events group by status,containing_class) ec group by status this would be more or less equalivalent to an aggregate-event-counts call with summarize_by=containing_class. Add Comment