Group by no longer supports now() as offset_interval

[jurom]

Bug report

This used to work in version 1.3.7, and I'm not sure if it was removed deliberately, or by accident (it was not mentioned in the [CHANGELOG] )(https://github.com/influxdata/influxdb/blob/master/CHANGELOG.md)

System info: InfluxDB version 1.4.2,

Steps to reproduce: Any query with offset in grouping by time set to now():

SELECT sum(amount) FROM payments WHERE time > now() - 2w AND time < now() GROUP BY time(1d, now())

Expected behavior: Results grouped by days, offset to current time.

Actual behavior: ERR: invalid time dimension offset: now()

[tux-00]

Same here.

[aidnguyen]

+1

[jsternberg]

This was not intentional. I'm sorry this took so long for me to see. I'll look into this so we can restore this functionality.

[tux-00]

@jsternberg Any news on this issue ?

[vmironenko]

+1

[jsternberg]

This is being backported for 1.5.2. We will unfortunately not be backporting this to the 1.4.x series.

Backport PR is #9651.