Company
Date Published
Author
Regan Kuchan
Word count
502
Language
English
Hacker News points
None

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.