compare query performance elastic and clickhouse
Start ES stack, in elastic
directory, run docker-compose up
. Kibana is running on port 5601.
Start Clickhouse stack, in clickhouse
directory, run docker-compose up
. TabixUI is running on port 18080. run sql script init.sql to to create log table in clickhouse.
Start vector container by running make start
in vector
directory to generate syslog data, and exported into ES and Clickhouse stack. The data ingestion pipeline is defined in file vector.toml
Run notebook in directory notebook
by command make run
, make docker
is required to build the docker image first. The notebook can be accessed at port 8888.
https://github.com/mymarilyn/clickhouse-driver
Python SDK https://elasticsearch-py.readthedocs.io/en/v7.11.0/