How do you INSERT into influxDB using the SQL-like interface?

influxdb
Ryan The Leach picture Ryan The Leach · Nov 23, 2017 · Viewed 12.8k times · Source

Is it possible to INSERT data into series / measurements using the SQL-like interface on InfluxDB?

Answer

peterdn picture peterdn · Nov 23, 2017

Yes, you can simply INSERT a Line Protocol string.

An example from Getting Started:

INSERT cpu,host=serverA,region=us_west value=0.64

A point with the measurement name of cpu and tags host and region has now been written to the database, with the measured value of 0.64.

Related questions

Can you delete data from influxdb?

How do you delete data from influxdb? The documentation shows it should be as simple as: delete from foo where time < now() -1h For some reason, influxdb rejects my delete statements saying "Delete queries can't have where clause …

Read More
How to format time in influxdb select query

I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?

Read More
InfluxDB - Getting only last value in query

Is possible to query only for the last value (or n-th value) of the results of a query? For example, in the query: SELECT value FROM response_times WHERE time > now() - 1h limit 1000; Is possible to get only …

Read More