OK thanks Sean. I think I've been failing to fully grok how series's work, i'll go and check that out. Thanks again.
On Wednesday, 30 November 2016 17:31:26 UTC+13, Sean Beckett wrote: > > Since you have multiple series because of the GROUP BY clause, you should > use SLIMIT to restrict the number of series returned. It's returning one > point each series, which is what LIMIT is intended to do. > > On Tue, Nov 29, 2016 at 5:52 PM, Glenn Davy <[email protected] > <javascript:>> wrote: > >> >> >> On Wednesday, 30 November 2016 12:08:23 UTC+13, Sean Beckett wrote: >>> >>> what's the actual query, syntax and all >>> >> >> 'select * from cpu group by role, host, cpu order by time asc limit 1' >> >> >> >>> >>> On Tue, Nov 29, 2016 at 3:45 PM, Glenn Davy <[email protected]> wrote: >>> >>>> Oh, ok thanks Sean. That also just solved another problem for me and >>>> that is the ruby influxdb gem was also not seperating out tags causing me >>>> issues, group by fixed that. >>>> >>>> The flow on problem for that however, is that limit 1 returns 349 >>>> results, limits discussed further down that same doc, but im not seeing >>>> why? am i missing something? >>>> >>>> On Wednesday, 30 November 2016 11:13:28 UTC+13, Sean Beckett wrote: >>>>> >>>>> Use GROUP BY * and the tags will be preserved as tags. >>>>> https://docs.influxdata.com/influxdb/v1.1/query_language/data_exploration/#common-issues-with-the-into-clause >>>>> >>>>> On Tue, Nov 29, 2016 at 2:46 PM, Glenn Davy <[email protected]> >>>>> wrote: >>>>> >>>>>> >That's a good workaround. There is no way to delete a field key >>>>>> without deleting every field on the point. Field keys can be >>>>>> overwritten, >>>>>> but only with the same >>>>>> >>>>>> turns out not to be such a good work around.. tags get converted to >>>>>> fields >>>>>> >>>>>> thanks for chipping in though Sean. >>>>>> >>>>>> On Wednesday, 30 November 2016 04:54:06 UTC+13, Sean Beckett wrote: >>>>>>> >>>>>>> That's a good workaround. There is no way to delete a field key >>>>>>> without deleting every field on the point. Field keys can be >>>>>>> overwritten, >>>>>>> but only with the same type (boolean, float, etc.) >>>>>>> >>>>>>> On Mon, Nov 28, 2016 at 9:01 PM, Glenn Davy <[email protected]> >>>>>>> wrote: >>>>>>> >>>>>>>> I guess as an alternative, i can do a select into, then drop the >>>>>>>> original measurement, then do a select into to get back to the >>>>>>>> original. >>>>>>>> >>>>>>>> On Tuesday, 29 November 2016 16:59:19 UTC+13, Glenn Davy wrote: >>>>>>>>> >>>>>>>>> Hey all >>>>>>>>> >>>>>>>>> Just wondering if its possible to delete field keys (and data >>>>>>>>> stored therein)? >>>>>>>>> >>>>>>>> -- >>>>>>>> Remember to include the version number! >>>>>>>> --- >>>>>>>> You received this message because you are subscribed to the Google >>>>>>>> Groups "InfluxData" group. >>>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>>> send an email to [email protected]. >>>>>>>> To post to this group, send email to [email protected]. >>>>>>>> Visit this group at https://groups.google.com/group/influxdb. >>>>>>>> To view this discussion on the web visit >>>>>>>> https://groups.google.com/d/msgid/influxdb/2390971d-d10f-4956-918a-9b14f6172fef%40googlegroups.com >>>>>>>> >>>>>>>> <https://groups.google.com/d/msgid/influxdb/2390971d-d10f-4956-918a-9b14f6172fef%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>> . >>>>>>>> >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Sean Beckett >>>>>>> Director of Support and Professional Services >>>>>>> InfluxDB >>>>>>> >>>>>> -- >>>>>> Remember to include the version number! >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "InfluxData" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to [email protected]. >>>>>> To post to this group, send email to [email protected]. >>>>>> Visit this group at https://groups.google.com/group/influxdb. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/influxdb/3cd5d8e9-851a-4283-a6ef-e9f89d347b41%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/influxdb/3cd5d8e9-851a-4283-a6ef-e9f89d347b41%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Sean Beckett >>>>> Director of Support and Professional Services >>>>> InfluxDB >>>>> >>>> -- >>>> Remember to include the version number! >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "InfluxData" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To post to this group, send email to [email protected]. >>>> Visit this group at https://groups.google.com/group/influxdb. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/influxdb/d057ce26-4d86-4593-89a2-09872353b95f%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/influxdb/d057ce26-4d86-4593-89a2-09872353b95f%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Sean Beckett >>> Director of Support and Professional Services >>> InfluxDB >>> >> -- >> Remember to include the version number! >> --- >> You received this message because you are subscribed to the Google Groups >> "InfluxData" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/influxdb. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/influxdb/399d3d41-43b1-4bf2-bfed-fe9681050257%40googlegroups.com >> >> <https://groups.google.com/d/msgid/influxdb/399d3d41-43b1-4bf2-bfed-fe9681050257%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sean Beckett > Director of Support and Professional Services > InfluxDB > -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/66abdf1d-0c8e-48bd-a43d-922d10482ab1%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
