Home / Companies / InfluxData / Blog / Post Details
Content Deep Dive

TL;DR InfluxDB Tech Tips - InfluxQL Support for Subqueries, CLI Support for Using a Retention Policy, and More

Blog post from InfluxData

Post Details
Company
Date Published
Author
Regan Kuchan
Word Count
490
Language
English
Hacker News Points
-
Summary

The new version of InfluxDB (1.2) introduces several exciting features, including support for subqueries in InfluxQL's SELECT statements, allowing users to apply a query as a condition in the enclosing query. Additionally, the Command Line Interface (CLI) now supports using alternative retention policies with the `USE` command, eliminating the need to fully qualify measurement names every time. Furthermore, a fix has been made for the `SAMPLE(*)` function, which now returns a random sample of points for every field in the measurement, regardless of its data type.