文件列表:

LICENSE.md (1530, 2021-07-21)
Makefile (566, 2021-07-21)
docker-compose.yml (2356, 2021-07-21)
docker/ (0, 2021-07-21)
docker/clickhouse/ (0, 2021-07-21)
docker/clickhouse/clickhouse_1.xml (200, 2021-07-21)
docker/clickhouse/clickhouse_2.xml (200, 2021-07-21)
docker/clickhouse/clickhouse_3.xml (200, 2021-07-21)
docker/clickhouse/config.xml (2174, 2021-07-21)
docker/clickhouse/users.xml (269, 2021-07-21)
docker/mariadb/ (0, 2021-07-21)
docker/mariadb/init/ (0, 2021-07-21)
docker/mariadb/init/00.sakila-schema.sql (24254, 2021-07-21)
docker/mariadb/init/01.sakila-data.sql (3351745, 2021-07-21)
docker/zookeper/ (0, 2021-07-21)
docker/zookeper/zoo.cfg (1853, 2021-07-21)
learning-units/ (0, 2021-07-21)
learning-units/00.01.introduction.md (2733, 2021-07-21)
learning-units/01.01.merge-tree-intro.md (7732, 2021-07-21)
learning-units/01.02.merge-tree-materialised-columns.md (3282, 2021-07-21)
learning-units/01.03.merge-tree-materialised-views-with-summing-merge-tree.md (5807, 2021-07-21)
learning-units/01.04.merge-tree-materialised-views-with-aggregating-merge-tree.md (8740, 2021-07-21)
learning-units/02.01.replicated-merge-tree.md (6726, 2021-07-21)
learning-units/03.01.mysql-dictionaries.md (7244, 2021-07-21)
learning-units/03.02.materialised-column-exploiting-redis-dictionaries.md (4246, 2021-07-21)
learning-units/04.01.mysql-database-engine.md (2871, 2021-07-21)
learning-units/05.01.rabbitmq-engine.md (4415, 2021-07-21)
learning-units/06.01.storage-policies.md (6057, 2021-07-21)
learning-units/07.01.data-transformation-json.md (1332, 2021-07-21)

# ClickHouse Play and Learn This project is a `docker-compose` based playground to explore and learn `ClickHouse`' features. It does not aim to replace the official documentation (https://clickhouse.tech/docs/en/) but, instead, to offer a learning path to get familiar with the most basic concepts. It does not include installation/setup instructions. It assumes a basic knowledge of `SQL`. - [ClickHouse playground](https://github.com/pachico/clickhouse-play-and-learn/blob/master/#clickhouse-playground) - [Requirements](https://github.com/pachico/clickhouse-play-and-learn/blob/master/#requirements) - [Versions](https://github.com/pachico/clickhouse-play-and-learn/blob/master/#versions) - [Installing the project](https://github.com/pachico/clickhouse-play-and-learn/blob/master/#installing-the-project) - [Working with the project](https://github.com/pachico/clickhouse-play-and-learn/blob/master/#working-with-the-project) - [Learning units](https://github.com/pachico/clickhouse-play-and-learn/blob/master/#learning-units) ## Requirements - docker-compose - make **Important**: this has been only tested in Linux. ## Versions This project starts containers with the following versions: - ClickHouse 21.3.13.9 (Altinity Certified) - Zookeeper 3.6.3 - MinIO 2021.6.17 - MariaDB 10.4.20 - Redis 6.2 - RabbitMQ 3.8.9 ## Installing the project Clone or download this repository and `cd` inside of it. ## Working with the project You will be asked to type (mostly copy and paste) things either in the terminal, either using `docker-compose`, `make` or, most of the times, inside ClickHouse after executing `make clickhouse`. **IMPORTANT CONVENTION**: if a code snippet starts with `docker-compose` we expect it to be executed in a terminal inside the folder where the project sits. If the snippet is a SQL sentence, instead, we expect it to be launched after logging in ClickHouse (`make clickhouse`). The most important operations are mapped to a `Makefile` recipe. Typing simple `make` will print out the available recipes and their description. The most basic ones are: - `make up`: Starts all the containers required to develop this project - `make down`: Shuts down all the containers and removes their volume - `make clickhouse`: Log into one ClickHouse instance These three you might need to remember since will be used frequently across this learning project. ## Learning units All units are under the folder [learning-units](https://github.com/pachico/clickhouse-play-and-learn/blob/master/learning-units). Units assume you have learned what explained in previous units, so it is recommended to follow them in order.

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：