search

pgspider / influxdb_fdw

InfluxDB Foreign Data Wrapper for PostgreSQL.
Other
58 stars 14 forks source link

GROUP BY does not work on field keys #3

Closed redsiren204 closed 3 years ago

redsiren204 commented 5 years ago

On the commit "GROUP BY push down (#2)", this error occurs:

select c2/2, sum(c2) * (c2/2) from ft1 group by c2/2 order by c2/2;
ERROR:  influxdb_fdw : error parsing query: found FROM, expected identifier, string, number, bool at line 1, char 9

It seems that GROUP BY function can not work with all field keys on InfluxDB. Please check and fix this issue.

mochizk commented 5 years ago

Thanks for the report. Currently GROUP BY works for only tag keys. I plan to fix this issue, but it may take a little time.

hrkuma commented 3 years ago

We have fixed in Release v0.3.0. So we'd like to close this issue.