Influx database limitations
Influx database use in
FactoryTalk Optix
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.
Feature | SQL | InfluxQL |
|---|---|---|
WHERE clause |  | |
GROUP BY clause | | not supported |
ORDER BY clause | | partial support |
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 |