Influx database limitations

SQL support

SQL and InfluxQL comparison

Feature	SQL	InfluxQL
WHERE clause
GROUP BY clause		not supported
ORDER BY clause		partial support: only ORDER BY time is supported. See https://docs.influxdata.com/influxdb/v2/query-data/influxql/explore-data/order-by/.
HAVING		not supported
LIMIT and SLIMIT clauses
OFFSET and SOFFSET clauses
EXTRACT clause		not supported
CHAR_LENGTH clause		not supported
Timezone queries	not supported	not supported
Subqueries
Regular expressions	not supported	not supported
CREATE statement	partial support	not supported
UPDATE statement		not supported
DELETE statement		partial support: the query requires either the FROM clause, the WHERE clause, or both. DELETE does not support fields (columns) in the WHERE clause. See https://docs.influxdata.com/influxdb/v2/query-data/influxql/manage-data/#delete-series-with-delete.
DROP statement	partial support	partial support: supports only DROP measurement (table). See https://docs.influxdata.com/influxdb/v2/query-data/influxql/manage-data/#delete-measurements-with-drop-measurement.
Aliases
AS table alias		not supported
AS column alias
JOIN clauses
INNER join		not supported
OUTER join		not supported
CROSS join		not supported
Operators
<, >, =, != (comparison operators)
AND, OR (logical operators)
not, IN, IS NULL, LIKE, EXISTS		not supported
BETWEEN
Functions
Window functions: ROW_NUMBER, RANK, DENSE_RANK		not supported
Aggregate functions: COUNT, MIN, MAX, AVG, SUM		partial support: ALL in COUNT, MIN, MAX, AVG, SUM is not supported by InfluxDB DISTINCT in MIN, MAX, AVG, SUM is not supported by InfluxDB

Other limitations

INSERT statement is not supported as part of an SQL query. To insert data to a database table, you must use the dedicated INSERT method
Influx database is sensitive on time data. Time on the source device and on the database device must be synchronized to keep data consistency. Data record with the same timestamp is overwritten by Influx, so you must carefully design data structure of the database side.
Influx may not add record for column custom named
time
, which is a restricted phrase.
STATUS
variable is not relevant to Influx database, because the connection is active only when data is transferred.