Industrial Internet Application Development

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.