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]> 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_langua >>>> ge/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-495 >>>>>>> 6-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-428 >>>>> 3-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/ms >>> gid/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]. > 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/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/CALGqCvONL%2BsnGnm9T1%3D5LjrKwwW8nRpjTBzWp8m47e-E9DpQ%2BA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
