- Getting started
- Creating projects
- OPC UA
- Graphic objects
- Predefined graphic objects
- Object and variable references
- Extending projects
- NetLogic
- Tutorials
- Dynamic links tutorial
- Graphic objects tutorial
- NetLogic tutorial
- OPC UA tutorial
Influx database limitations
Influx database has specific limitations, which are described in this
section.
SQL support
Influx database does not directly support SQL. A parser translates the SQL queries to
Influx-based query language. Only specific SQL commands are supported. For more information
on SQL queries, see SQL queries.
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:
|
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 namedtime, which is a restricted phrase.
- STATUSvariable is not relevant to Influx database, because the connection is active only when data is transferred.
influx
Provide Feedback