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

Question

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

rjdkolb · Accepted Answer · 2018-09-25 08:17:43Z

9

Yes, you can simply INSERT a Line Protocol string.

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.

edited Sep 25, 2018 at 8:17

rjdkolb

12.1k13 gold badges79 silver badges94 bronze badges

answered Nov 23, 2017 at 15:45

peterdn

2,4961 gold badge24 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ben Slade Over a year ago

Since "value" a keyword, I think it would be clearer if it were uppercased in this example (to show newbies that it's not just another tag name)

Hacker Over a year ago

Can i insert multiple values like value=0.64, value1=100??

Paul A Jungwirth Over a year ago

@BenSlade value is not a keyword. It's the name of your "field". (cpu is the "measurement".) You can name your fields whatever you like, e.g. temp. @Hacker yes you can have many, e.g. load_avg=0.64,temp=90.

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related