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

TL;DR InfluxDB Tech Tips - Querying Data in a Non-DEFAULT Retention Policy, Checking Field Types, and Querying vs. Writing Booleans

Blog post from InfluxData

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

InfluxDB provides guidance on querying data in non-DEFAULT retention policies, checking field types, and the differences between querying and writing booleans. When querying data in a retention policy that is not the DEFAULT policy, it's necessary to fully qualify the measurement by specifying the database and retention policy. The SHOW FIELD KEYS query can be used to see the data type of a field starting with InfluxDB version 1.0. Additionally, boolean syntax differs for writes and queries, requiring the use of `true`, `True`, or `TRUE` to reference that value in a query.