We have just released version 0.3 of the Foreign Data Wrapper for InfluxDB.
This release can work with PostgreSQL 9.6, 10, 11, 12 and 13.
This release supports following features :
- Support PostgreSQL 13
- Support new "tags" option for specifing tag keys
- Fix some bugs
- Fix influxdb not support compare time column with OR
- Fix influxdb not support IN/NOT IN
- Fix invalid input syntax for type integer
- Fix error GROUP BY only works with time and tag dimensions
- Fix time argument and having clause
- Fix influxdb does not support DISTINCT within aggregate except count()
- Fix error parsing with LIKE operator
- Fix InfluxDB return 0 rows when related tag key operation
- Fix build on macOS
- Fix WHERE string comparision other than = and != operators
- Fix mix usage of aggregate function and arithmetic
Limitations :
- INSERT, UPDATE and DELETE are not supported.
- Result sets have different number of rows depending on specified target list.
- Complex boolean conditions not allowed in InfluxDB like WHERE b = (a = true)
may cause error.
- Conditions including NULL may cause error.
This is developed by Toshiba Software Engineering & Technology Center.
Please see the repository for details.
Source repository : https://github.com/pgspider/influxdb_fdw