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] > <javascript:>> 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] <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/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. For more options, visit https://groups.google.com/d/optout.
