General Notes

  • A query must at least select one field, otherwise no result will be returned.
  • Unsigned integers are not natively supported for the database. Therefore, a WHERE for variables of this type might provide unexpected query results.
  • Requesting an" unsigned int" from the database, requires to manually cast the result value to an unsigned type.
  • The time column is always in UTC time and it is always retrieved as the first column.
  • If a dpQuery with SORT BY 0 GROUP BY SECS(<num>) is used to get downsampling data, a result is not returned in an InfluxDB® backend where correction values are set.