Scripts

mkdir containers
cd containers
mkdir influxdb
cd influxdb

Launch influxdb 1.8 via Docker container

podman run -d --rm -p 8086:8086 \
-e INFLUXDB_DB=db0 \
-e INFLUXDB_ADMIN_ENABLED=true \
-e INFLUXDB_ADMIN_USER=admin \
-e INFLUXDB_ADMIN_PASSWORD=supersecretpassword \
-v "/$PWD/data:/var/lib/influxdb" \
--name=influx_bigdata_class \
influxdb:1.8.10

Launch influx CLI

podman exec -it influx_bigdata_class bash

Invoke SQL Client

influx

create Database homeoffice;

use homeoffice;

INSERT temperature,officename=O1 value=23.1
INSERT temperature,officename=O1 value=23.2
INSERT temperature,officename=O1 value=23.1
INSERT temperature,officename=O1 value=23.3
INSERT temperature,officename=O1 value=23.2

INSERT sound,officename=O1 value=50.1
INSERT sound,officename=O1 value=50.2
INSERT sound,officename=O1 value=55
INSERT sound,officename=O1 value=50.1
INSERT sound,officename=O1 value=50.25

Select Mean("value") from temperature group by "officename"

select * from temperature

Using HTTP API Protocol

curl -i -X POST 'http://localhost:8086/write?db=homeoffice' --data-binary 'temperature,officename=O1 value=99.8'

select * from temperature

curl -G 'http://localhost:8086/query?pretty=true' --data-urlencode "db=homeoffice" --data-urlencode "q=SELECT * FROM temperature WHERE officename='O1'"

Office Database

create database office

use office

show measurements

INSERT temperature,officeName=mainoffice,location=downtown,city=newyork value=72.5

INSERT temperature,officeName=mainoffice,location=downtown,city=newyork value=72.5

INSERT temperature,officeName=branchoffice,location=uptown,city=newyork value=74.2

INSERT temperature,officeName=satelliteoffice,location=financialdistrict,city=sfo value=68.9

INSERT temperature,officeName=regionalhq,location=midtown,city=chicago value=71.1

INSERT temperature,officeName=salesoffice,location=missiondistrict,city=sfo value=69.7

INSERT temperature,officeName=mainoffice,location=downtown,city=newyork value=72.8

INSERT temperature,officeName=branchoffice,location=uptown,city=newyork value=73.9

INSERT temperature,officeName=satelliteoffice,location=financialdistrict,city=sfo value=69.2

INSERT temperature,officeName=regionalhq,location=midtown,city=chicago value=70.5

INSERT temperature,officeName=salesoffice,location=missiondistrict,city=sfo value=70.1


INSERT humidity,officeName=mainoffice,location=downtown,city=newyork value=45.2
INSERT humidity,officeName=branchoffice,location=uptown,city=newyork value=48.7
INSERT humidity,officeName=satelliteoffice,location=financialdistrict,city=sfo value=52.1
INSERT humidity,officeName=regionalhq,location=midtown,city=chicago value=39.8
INSERT humidity,officeName=salesoffice,location=missiondistrict,city=sfo value=51.3
INSERT humidity,officeName=mainoffice,location=downtown,city=newyork value=46.5
INSERT humidity,officeName=branchoffice,location=uptown,city=newyork value=47.9
INSERT humidity,officeName=satelliteoffice,location=financialdistrict,city=sfo value=53.4
INSERT humidity,officeName=regionalhq,location=midtown,city=chicago value=41.2
INSERT humidity,officeName=salesoffice,location=missiondistrict,city=sfo value=50.7

-- Get the maximum temperature and humidity for each office location

SELECT officeName, location, max(value) AS max_temperature FROM temperature GROUP BY officeName, location;

-- Calculate the 3-hour moving average of temperatures for the "Main Office" in New York

SELECT mean("value") AS "moving_avg" FROM "temperature" WHERE "officeName" = 'mainoffice' AND "city" = 'newyork' GROUP BY time(3m)

Quer to compare temperature and humidity for each location

SELECT mean("temp_value") AS "avg_temp", mean("humidity_value") AS "avg_humidity" FROM ( SELECT mean(value) AS "temp_value" FROM "temperature" GROUP BY "location"),(SELECT mean(value) AS "humidity_value" FROM "humidity" GROUP BY "location" ) GROUP BY "location"