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