Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title
Russell Mull updated an issue
PuppetDB / PDB-3838
Queries to the facts endpoint generates jsonb_each
Change By:
Russell Mull
This happens for simple equality:{code:bash}puppet query "facts[name, value, count()] { name ='is_virtual' group by value }"{code}does this. Example command:{code:bash}puppet query "facts[name, value, count()] { name in ['is_virtual','kernel','aio_agent_version'] group by name, value }"{code}And the resulting query plan:(attached in facts_entitiy_jsonb_each.sql)
Add Comment
This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93)
--
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 https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell commented on PDB-3838 Re: Queries to the facts endpoint generates jsonb_each Russell Mull Release notes? Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell updated an issue PuppetDB / PDB-3838 Queries to the facts endpoint generates jsonb_each Change By: Jeff Yarnell Fix Version/s: PDB 5.2.1 Add Comment This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell assigned an issue to Russell Mull PuppetDB / PDB-3838 Queries to the facts endpoint generates jsonb_each Change By: Jeff Yarnell Assignee: Russell Mull Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell updated an issue PuppetDB / PDB-3838 Queries to the facts endpoint generates jsonb_each Change By: Jeff Yarnell Story Points: 3 Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell updated an issue PuppetDB / PDB-3838 Queries to the facts endpoint generates jsonb_each Change By: Jeff Yarnell Sprint: Data Platorm Platform 2018- 02 03 - 28 14 Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell commented on PDB-3838 Re: Queries to the facts endpoint generates jsonb_each Jeff Yarnell Talk to CS about our delaying this for one sprint Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell updated an issue PuppetDB / PDB-3838 Queries to the facts endpoint generates jsonb_each Change By: Jeff Yarnell Team: Data Platform Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title Jeff Yarnell updated an issue PuppetDB / PDB-3838 Queries to the facts endpoint generates jsonb_each Change By: Jeff Yarnell Sprint: Data Platorm 2018-02-28 Add Comment This message was sent by Atlassian JIRA (v7.5.1#75006-sha1:7df2574) -- 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 https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.
Jira (PDB-3838) Queries to the facts endpoint generates jsonb_each
Title: Message Title
Erik Hansen created an issue
PuppetDB / PDB-3838
Queries to the facts endpoint generates jsonb_each
Issue Type:
Bug
Assignee:
Unassigned
Attachments:
facts_entitiy_jsonb_each.sql
Created:
2018/02/07 8:41 AM
Priority:
Normal
Reporter:
Erik Hansen
Example command:
puppet query "facts[name, value, count()] { name in ['is_virtual','kernel','aio_agent_version'] group by name, value }"
And the resulting query plan: (attached in facts_entitiy_jsonb_each.sql)
Add Comment
