Discussion:
[influxdb] InfluxDB sum() - ERR: unsupported sum iterator type: *influxql.stringInterruptI
sv.kirsten via InfluxData
2017-05-10 12:16:30 UTC
Permalink
I want to use the aggregate function sum() but I get this error message :

ERR: unsupported sum iterator type: *influxql.stringInterruptIterator
select sum("value") from BASIC_STATS WHERE cluster = 'fra-prod-cluster-01'
ERR: unsupported sum iterator type: *influxql.stringInterruptIterator
select sum(*) from BASIC_STATS WHERE cluster = 'fra-prod-cluster-01'
Then I got nothing.

The same is with functions like : max(), min(), mean(), sum()
They all produce the error message :
ERR: unsupported XXX iterator type: *influxql.stringInterruptIterator
--
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 influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
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/8dc0abb8-4a34-4dfb-8afa-94e7edf71b4d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
sv.kirsten via InfluxData
2017-05-10 13:44:12 UTC
Permalink
I've found the reason.
The datatype was set to STRING, as I changed the type to INTEGER , it was working fine
--
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 influxdb+***@googlegroups.com.
To post to this group, send email to ***@googlegroups.com.
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/a1533d60-0112-44ea-89e6-92418a47d090%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...