Example – select all fields and tags from a single measurement

The query will select all fields and tags from the h2o_fee measurement:

> SELECT * FROM "h2o_feet"name: h2o_feet--------------time level description location water_level2015-08-18T00:00:00Z below 3 feet santa_monica 2.0642015-08-18T00:00:00Z between 6 and 9 feet coyote_creek 8.12[...]2015-09-18T21:36:00Z between 3 and 6 feet santa_monica 5.0662015-09-18T21:42:00Z between 3 and 6 feet santa_monica 4.938
If you are using a CLI, you will need to enter USE NOAA_water_database before running the query. Otherwise, the HTTP API will automatically query the DEFAULT retention policy of the database.

Get Industrial Internet Application Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.