Clickhouse客户-代码: 62。DB::Exception:空查询

Question

我试图使用clickhouse-server和clickhouse-client服务来运行Docker和Docker Compose。基于clickhouse停靠-撰写文件和另一组样本，我在另一组样本文件中创建了服务，如下所示：

docker-compose.yml:

    ch_server:
      container_name: myapp_ch_server
      image: yandex/clickhouse-server
      ports:
        - "8181:8123"
        - "9000:9000"
        - "9009:9009"
      ulimits:
        nproc: 65535
        nofile:
          soft: 262144
          hard: 262144
      volumes: 
        - ./ch_db_data:/var/lib/clickhouse/
        - ./ch_db_logs:/val/log/clickhouse-server/
      networks:
        - myapp-network

    ch_client:
      container_name: myapp_ch_client
      image: yandex/clickhouse-client
      command: ['--host', 'ch_server']
      networks:
        - myapp-network

当我运行docker-compose up命令时，clickhouse-client服务会出现以下异常：

myapp_ch_client | Code: 62. DB::Exception: Empty query
myapp_ch_client exited with code 62

你知道如何修复这个错误吗？

Answer 1

它只需要在命令params中传递SQL-查询：

version: "2.4"

services:
  ch_server:
    container_name: myapp_ch_server
    image: yandex/clickhouse-server
    ports:
      - "8123:8123"
      - "9000:9000"
      - "9009:9009"
    ulimits:
      nproc: 65535
      nofile:
        soft: 262144
        hard: 262144
    volumes: 
      - ./ch_db_data:/var/lib/clickhouse/
      - ./ch_db_logs:/var/log/clickhouse-server/
    networks:
      - myapp-network
    healthcheck:
      test: wget --no-verbose --tries=1 --spider localhost:8123/ping || exit 1
      interval: 2s
      timeout: 2s
      retries: 16

  ch_client:
    container_name: myapp_ch_client
    image: yandex/clickhouse-client
    command: ['--host', 'ch_server', '--query', 'select * from system.functions order by name limit 4']
    networks:
      - myapp-network
    depends_on:
      ch_server:
        condition: service_healthy

networks:
    myapp-network:

在拼图中定义clickhouse-client是没有意义的。clickhouse-client通常在docker-组合文件之外运行：

1. 定义服务器(如集群的节点)、动物园管理员、Apache等。例如，让我们考虑ClickHouse的一个节点的配置：

version: "2.4"

services:
  ch_server:
    container_name: myapp_ch_server
    image: yandex/clickhouse-server
    ports:
      - "8123:8123"
      - "9000:9000"
      - "9009:9009"
    ulimits:
      nproc: 65535
      nofile:
        soft: 262144
        hard: 262144
    volumes: 
      - ./ch_db_data:/var/lib/clickhouse/
      - ./ch_db_logs:/var/log/clickhouse-server/
    networks:
      - myapp-network
    healthcheck:
      test: wget --no-verbose --tries=1 --spider localhost:8123/ping || exit 1
      interval: 2s
      timeout: 2s
      retries: 16

networks:
    myapp-network:

1. 在单独的终端中运行clickhouse-client。

cd _folder_where_docker-compose_located

docker-compose exec ch_server clickhouse-client

Answer 2

2021年版本为本教程https://dev.to/titronium/clickhouse-server-in-1-minute-with-docker-4gf2

  clickhouse-client:
    image: yandex/clickhouse-client:latest
    depends_on:
      - clickhouse-server
    links:
      - clickhouse-server
    entrypoint:
      - /bin/sleep
    command:
      - infinity

最后一行command: - infinity意味着它将永远在那里等待连接

Answer 3

实际上，您可以访问ClickHouse服务器命令行上的一个ClickHouse客户端。

您可以轻松地连接到服务器容器并调用

clickhuse-client