Questions tagged clickhouse

Explore the latest questions and answers asked by our top developers.

Can’t connect to the local clickhouse database from docker container ubuntu

Docker version 20.10.1 Can’t connect to the local clickhouse database from docker container ubuntu docker-compose.yml version: "3.7" services: consumer-db: build: ./src/consumer-db restart: always env_file: – ./.env networks: – main_net depends_on: – rabbitmq extra_hosts: – "host.docker.internal:host-gateway" rabbitmq: image: ‘rabbitmq:3.6-management-alpine’ ports: – ‘5672:5672’ – ‘15672:15672’ networks: – main_net networks: main_net: external: True from execute from clickhouse_driver […]

By Gardina
Categorised as clickhouse, docker, docker-compose, python Tagged , , ,

Clickhouse cluster setup with zookpeer in Docker in Windows Machine

I created three zookeeper nodes in docker with the following commands. docker run -d -p 2181:2181 –name zookeeper_node1 –privileged –restart always –network zoonet –ip -v C:/zookeeper/zk_node1/volumes/data:/data -v C:/zookeeper/zk_node1/volumes/datalog:/datalog -v C:/zookeeper/zk_node1/volumes/logs:/logs -e ZOO_MY_ID=1 -e "ZOO_SERVERS=server.1=;2181 server.2=;2181 server.3=;2181" 36c607e7b14d docker run -d -p 2182:2181 –name zookeeper_node2 –privileged –restart always –network zoonet –ip -v C:/zookeeper/zk_node2/volumes/data:/data -v […]

By Sai Teja Pamarthi
Categorised as apache-zookeeper, clickhouse, docker Tagged , ,

clickhouse – CollapsingMergeTree works like ReplacingMergeTree

I created docker container with clickhouse-server inside with mounted directory. docker run -d –name clickserver -p 8213:8123 -v C:Usersmankov.kDesktopTest_taskepay:/data chserver chserver is a docker image created via Dockerfile FROM clickhouse/clickhouse-server: WORKDIR /data docker build -t chtest8 . Now I have a csv file called data.csv and I am trying to isert it inside CollapsingMergeTree table. […]

By Kirill Mankov
Categorised as clickhouse, docker Tagged ,

Cannot create the replica table Code: 253, Exception: Replica /clickhouse/tables/[…] already exists (version Docker

I am trying to set up a ClickHouse cluster with 1 shard and 2 replicas using docker. For testing purposes, I only have one zookeeper in a single container and two ClickHouse containers. Creating non replicated tables is possible, but it is not possible to use replicated tables. when I create a replicated table CREATE […]

By Pierre Louis
Categorised as clickhouse, docker, docker-compose Tagged , ,

/bin/sh: 1: clickhouse: Operation not permitted

I am creating Clickhouse docker image for version, Dockerfile gets build successfully but when I tried to run it using docker run <imagename> command, it says /bin/sh: 1: exec: /usr/bin/clickhouse-server: Operation not permitted Dockerfile: FROM ubuntu:20.04 ENV CH_VERSION COPY default-password.xml /etc/clickhouse-server/users.d/default-password.xml RUN apt-get update RUN apt-get install –yes –no-install-recommends apt-transport-https apt-utils dirmngr gnupg […]

Click house build is stuck after inserting user password

Docker file FROM ubuntu:20.04 ENV CH_VERSION RUN apt-get update && apt-get install –yes –no-install-recommends apt-transport-https apt-utils dirmngr gnupg && apt-key adv –keyserver –recv E0C56BD4 && echo "deb main/" | tee /etc/apt/sources.list.d/clickhouse.list && apt-get update && apt-get install –allow-unauthenticated -y clickhouse-client=${CH_VERSION} clickhouse-server=${CH_VERSION} clickhouse-common-static=${CH_VERSION} libgcc-7-dev tzdata libreadline-dev curl && rm -rf /var/lib/apt/lists/* /var/cache/debconf /tmp/* […]

By Rishabh Shah
Categorised as clickhouse, devops, docker, dockerfile Tagged , , ,

Error running ClickHouse Docker on MacBook M1

I’m running ClickHouse Docker image on MacBook M1 and getting the following error. clickhouse-02_1 | runtime: failed to create new OS thread (have 2 already; errno=22) clickhouse-02_1 | fatal error: newosproc clickhouse-02_1 | clickhouse-02_1 | runtime stack: clickhouse-02_1 | runtime.throw(0x4cb21f, 0x9) clickhouse-02_1 | /usr/local/go/src/runtime/panic.go:566 +0x95 clickhouse-02_1 | runtime.newosproc(0xc420028000, 0xc420037fc0) clickhouse-02_1 | /usr/local/go/src/runtime/os_linux.go:160 +0x194 clickhouse-02_1 | […]

Categorised as apple-m1, clickhouse, docker Tagged , ,

Kafka Connect Error : java.lang.NoClassDefFoundError: org/apache/http/conn/HttpClientConnectionManager

I’m using docker with kafka and clickhouse. I want to connect ‘KsqlDB table’ and ‘clickhouse’ using ‘kafka connect’. So I referred to this document and modified ‘docker composite’. here is my docker-compose — version: ‘2’ services: zookeeper: image: confluentinc/cp-zookeeper:6.2.1 hostname: zookeeper container_name: zookeeper ports: – "2181:2181" environment: ZOOKEEPER_CLIENT_PORT: 2181 ZOOKEEPER_TICK_TIME: 2000 broker: image: confluentinc/cp-server:6.2.1 hostname: […]

Clickhouse && Docker Connection refused

Error ‘Connection refused’ I tried a lot, but to no avail. My configs. docker-compose.yml gc-clickhouse: image: yandex/clickhouse-server: container_name: clickhouse ulimits: nofile: soft: 262144 hard: 262144 volumes: – ${GC_CLICKHOUSE_DATA_PATH:-../data/clickhouse}:/var/lib/clickhouse:cached – /etc/localtime:/etc/localtime:ro – /etc/timezone:/etc/timezone:ro – ./docker/clickhouse/config.xml:/etc/clickhouse-server/config.xml – ./docker/clickhouse/users.xml:/etc/clickhouse-server/users.xml ports: – 8123:8123 – 9000:9000 networks: – bridge Config listen config.xml <listen_host>::</listen_host> <!– Same for hosts with disabled ipv6:–> […]

Categorised as clickhouse, docker Tagged ,

Difference in data size for the Clickhouse backups

I am running with 6 ClickHouse pods in K8s (3shards*2replicas), with 50GB of data. I am trying to backup the data using the Clickhouse-backup repo NAME READY STATUS RESTARTS AGE chi-ch-cluster-clickhouse-cp-0-0-0 2/2 Running 0 20d chi-ch-cluster-clickhouse-cp-0-1-0 2/2 Running 0 20d chi-ch-cluster-clickhouse-cp-1-0-0 2/2 Running 0 20d chi-ch-cluster-clickhouse-cp-1-1-0 2/2 Running 0 20d chi-ch-cluster-clickhouse-cp-2-0-0 2/2 Running 0 […]

1 2 3

Still Have Questions?

Our dedicated development team is here for you!

We can help you find answers to your question for as low as 5$.

Contact Us