[influxdb] Spread function not working on 1.2 v

[a***@gmail.com]

Hi All,

I am facing certain problems in v1.2, which I migrated to recently. Some of my queries which were running smooth are not working properly:

1. Spread: When I execute following query
SELECT MAX("M23_CNT") FROM "pcount" WHERE time >= '2017-08-20T23:48:00Z' AND time <= '2017-08-24T00:54:00Z'
I am getting error:
Server returned error: unsupported spread iterator type: *influxql.stringInterruptIterator

2. When I execute any query with relative time,eg:
select M23_CNT from pcount where time > now() - 3h

In the result I am getting data even older than 3 hours before data.

Am I doing some basic mistake?

Manish

[a***@gmail.com]

It was my bad. The data I was adding was added as string, that's why it was creating error for spread function.

But fetching data relative to time is still an unsolved problem.

Post by a***@gmail.com
Hi All,
1. Spread: When I execute following query
SELECT MAX("M23_CNT") FROM "pcount" WHERE time >= '2017-08-20T23:48:00Z' AND time <= '2017-08-24T00:54:00Z'
Server returned error: unsupported spread iterator type: *influxql.stringInterruptIterator
select M23_CNT from pcount where time > now() - 3h
In the result I am getting data even older than 3 hours before data.
Am I doing some basic mistake?
Manish