InfluxDB 1.x handbook

Please note

Content on this page may need an update.

Query language

InfluxDB 1.x supports both the Influx Query Language (InfluxQL) and the Flux data scripting language.

Walkthrough

Prerequisites

Define hostname of InfluxDB server:

export INFLUXDB_HOST=daq.example.org

Authentication

Enable auth-only access by creating admin user:

$ curl --silent --get 'http://$INFLUXDB_HOST:8086/query?pretty=true' --user root:root --data-urlencode 'q=CREATE USER admin WITH PASSWORD 'admin' WITH ALL PRIVILEGES'

See also

https://docs.influxdata.com/influxdb/v1.1/query_language/authentication_and_authorization/

Database operations

Create database:

curl --silent --get 'http://$INFLUXDB_HOST:8086/query?pretty=true' --user admin:admin --data-urlencode 'q=CREATE DATABASE "hiveeyes_100"'

List databases:

curl --silent --get 'http://$INFLUXDB_HOST:8086/query?pretty=true' --user admin:admin --data-urlencode 'q=SHOW DATABASES' | jq '.'

Drop database:

curl --silent --get 'http://$INFLUXDB_HOST:8086/query?pretty=true' --user admin:admin --data-urlencode 'q=DROP DATABASE "hiveeyes_100"'

Writing

See also

https://docs.influxdata.com/influxdb/v1.1/guides/writing_data/

Querying

Query database using curl:

# pretty-print json using jq
curl --silent --get 'http://$INFLUXDB_HOST:8086/query?pretty=true' --user admin:admin --data-urlencode 'db=hiveeyes_100' --data-urlencode 'q=select * from "1.99";' | jq '.'

See also

https://docs.influxdata.com/influxdb/v1.1/guides/querying_data/

Querying with Python

from influxdb.client import InfluxDBClient
client = InfluxDBClient('$INFLUXDB_HOST', 8086, 'root', 'root', 'kotori')
client.query('select * from telemetry;')

See also

https://pypi.python.org/pypi/influxdb

Backup and Restore

Backup example:

influxd backup -database hiveeyes_25a0e5df_9517_405b_ab14_cb5b514ac9e8 -host swarm.hiveeyes.org:8088 hiveeyes_25a0e5df_9517_405b_ab14_cb5b514ac9e8

Restore example:

influxd restore -datadir /var/lib/influxdb/data -database hiveeyes_25a0e5df_9517_405b_ab14_cb5b514ac9e8 hiveeyes_25a0e5df_9517_405b_ab14_cb5b514ac9e8

See also

https://docs.influxdata.com/influxdb/v1.1/administration/backup_and_restore/

Export and Import

CSV

Export:

http GET https://swarm.hiveeyes.org/api/hiveeyes/25a0e5df-9517-405b-ab14-cb5b514ac9e8/3756782252718325761/1/data.csv from=2016-01-01 --download

Import:

export GOPATH=`pwd`
go get -v github.com/jpillora/csv-to-influxdb

./bin/csv-to-influxdb --batch-size=1 --timestamp-column=time --timestamp-format="2006-01-02 15:04:05.000000000" --server=http://localhost:8086 --database=hiveeyes_25a0e5df_9517_405b_ab14_cb5b514ac9e8 --measurement=3756782252718325761_1 ../../data/25a0e5df_9517_405b_ab14_cb5b514ac9e8_3756782252718325761_1_20160101T000000_20160705T195237.csv
2016/07/05 21:55:15 Done (wrote 34304 points)