This page aims to ease the transition from InfluxDB 0.12 to InfluxDB 0.13. It is not intended to be a comprehensive list of the differences between the versions. See InfluxDB’s Changelog for detailed release notes.
- collectd and OpenTSDB support multiple listeners
/queryendpoint request behavior
GROUP BY time()interval boundaries
- Configuration file environment variable
- New query management features
- New functions
collectd and OpenTSDB support multiple listeners
InfluxDB 0.13 supports multiple listeners for the collectd and OpenTSDB inputs.
Because of changes to the configuration file (the headers
[opentsdb] are now
we recommend that users
a default configuration file and manually migrate customizations into it before
launching version 0.13.
Deprecated /query endpoint request behavior
Starting with InfluxDB 0.13, all queries sent to the
/query endpoint that are
SHOW queries should be
POST requests to the
SELECT and non-
SHOW queries will continue to work with
/query endpoint but this behavior is deprecated in version 0.13 and
will no longer work in version 1.0.
InfluxDB 0.13 introduces the
The query deletes all points from series in a database.
, it does not drop series from the index and it supports time intervals in the
The query takes the following form where you must specify either the
clause or the
DELETE FROM <measurement_name> WHERE [<tag_key>='<tag_value>'] | [<time interval>]
for more on the
DELETE syntax and sample queries.
Configure GROUP BY time() interval boundaries
With InfluxDB 0.13, users can alter
GROUP BY time()’s default rounded
calendar time boundaries by including an offset interval.
The new syntax is:
SELECT [...] GROUP BY time(<time_interval>[,<offset_interval>])
For an in-depth discussion of the
offset_interval, see the discussion in
Configuration file environment variable
With InfluxDB 0.13, users can set the environment variable
INFLUXDB_CONFIG_PATH to the path of their configuration file.
For more information see Using Configuration Files.
New query management features
Version 0.13 offers a new configuration setting for query management.
log-queries-after tells InfluxDB to log a query if the query runs
longer than a given time period.
See the Query Management page for more information.
InfluxDB 0.13 provides one new InfluxQL function.
ELAPSED() returns the
difference between subsequent timestamps in a single field.
See Functions for the
syntax and sample queries.
InfluxDB 0.13 also updates the behavior of selector functions to return the relevant timestamp:
> SELECT FIRST(water_level) FROM h2o_feet
0.12 return format: 0.13 return format:
name: h2o_feet name: h2o_feet -------------- -------------- time first time first 1970-01-01T00:00:00Z 8.12 2015-08-18T00:00:00Z 8.12