Explore data using InfluxQL
To start exploring data with InfluxQL, do the following:
(Optional) If you would like to use the data used in the examples below, download the NOAA sample data.
Use the InfluxQL
SELECTstatement with other key clauses to explore your data.
- SELECT statement
- WHERE clause
- GROUP BY clause
- ORDER BY clause
- LIMIT and SLIMIT clauses
- OFFSET and SOFFSET clauses
- Time and timezone queries
- Regular expressions
Download sample data
The example InfluxQL queries in this documentation use publicly available National Oceanic and Atmospheric Administration (NOAA) data.
To download a subset of NOAA data used in examples, run the script under NOAA water sample data (for example, copy and paste the script into your Data Explorer - Script Editor), and replace “example-org” in the script with the name of your InfluxDB organization.
Let’s get acquainted with this subsample of the data in the
|2019-08-18T00:00:00Z||between 6 and 9 feet||coyote_creek||8.1200000000|
|2019-08-18T00:00:00Z||below 3 feet||santa_monica||2.0640000000|
|2019-08-18T00:06:00Z||between 6 and 9 feet||coyote_creek||8.0050000000|
|2019-08-18T00:06:00Z||below 3 feet||santa_monica||2.1160000000|
|2019-08-18T00:12:00Z||between 6 and 9 feet||coyote_creek||7.8870000000|
|2019-08-18T00:12:00Z||below 3 feet||santa_monica||2.0280000000|
The data in the
occurs at six-minute time intervals.
This measurement has one tag key
location) which has two tag values:
The measurement also has two fields:
level description stores string field values
water_level stores float field values.
Configure timestamps in the InfluxQL shell
By default, the InfluxQL shell returns timestamps in nanosecond UNIX epoch format by default. To return human-readable RFC3339 timestamps instead of Unix nanosecond timestamps, use the precision helper command ` to configure the timestamp format:
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.