clickhouse

Example integration with ClickHouse

Run docker image ClickHouse database

$ mkdir $HOME/some_clickhouse_database
$ docker run -d -p 18123:8123 -p19000:9000 -p19090:9090 --name some-clickhouse-server --ulimit nofile=262144:262144 --volume=$HOME/some_clickhouse_database:/var/lib/clickhouse yandex/clickhouse-server 

Then create database and table

CREATE DATABASE develop;

CREATE TABLE IF NOT EXISTS events (
	eid UInt32,
	ip String,
	etype UInt32 default 0,
	price UInt64 default 0,
	created DATETIME default now()
)
ENGINE = MergeTree()
ORDER BY created
;

INSERT INTO events (eid, ip, etype, price, created)
VALUES
	(1, '192.168.1.1', 100, 1000000, '2022-10-01 12:00:00'),
	(2, '127.0.0.1', 100, 1000000, '2022-10-02 12:00:00'),
	(3, '192.168.1.1', 100, 1000000, '2022-10-03 12:00:00'),
	(4, '127.0.0.1', 200, 1000000, '2022-10-01 12:00:00'),
	(5, '192.168.1.1', 200, 1000000, '2022-10-02 12:00:00'),
	(6, '127.0.0.1', 200, 1000000, '2022-10-03 12:00:00'),
	(7, '192.168.1.1', 300, 1000000, '2022-10-01 12:00:00'),
	(8, '127.0.0.1', 300, 1000000, '2022-10-02 12:00:00'),
	(9, '192.168.1.1', 300, 1000000, '2022-10-04 12:00:00')
;

Run example

go run examples/clickhouse/main.go