{"id":6251,"date":"2026-02-26T10:37:43","date_gmt":"2026-02-26T07:07:43","guid":{"rendered":"https:\/\/parmin.cloud\/blog\/?p=6251"},"modified":"2026-02-26T10:37:43","modified_gmt":"2026-02-26T07:07:43","slug":"%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d9%86%d8%b5%d8%a8-%d9%88-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-clickhouse-%d8%af%d8%b1-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/parmin.cloud\/blog\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d9%86%d8%b5%d8%a8-%d9%88-%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-clickhouse-%d8%af%d8%b1-ubuntu-20-04\/","title":{"rendered":"\u0622\u0645\u0648\u0632\u0634 \u0646\u0635\u0628 \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 ClickHouse \u062f\u0631 Ubuntu 20.04"},"content":{"rendered":"

\u0645\u0642\u062f\u0645\u0647<\/h2>\n

ClickHouse<\/strong> \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u062a\u062d\u0644\u06cc\u0644\u06cc \u0645\u062a\u0646\u200c\u0628\u0627\u0632 (Open Source)\u060c \u0633\u062a\u0648\u0646\u200c\u0645\u062d\u0648\u0631 (Column-Oriented)<\/strong> \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0633\u0637 Yandex \u0628\u0631\u0627\u06cc \u0633\u0646\u0627\u0631\u06cc\u0648\u0647\u0627\u06cc OLAP<\/strong> \u0648 Big Data<\/strong> \u062a\u0648\u0633\u0639\u0647 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n

\u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc ClickHouse \u0627\u0632 \u067e\u0631\u062f\u0627\u0632\u0634 \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af (Real-Time Query Processing) \u0628\u0627\u0639\u062b \u0645\u06cc\u200c\u0634\u0648\u062f \u0628\u0631\u0627\u06cc \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0647 \u0646\u062a\u0627\u06cc\u062c \u062a\u062d\u0644\u06cc\u0644\u06cc \u062f\u0631 \u062d\u062f \u0686\u0646\u062f \u0645\u06cc\u0644\u06cc\u200c\u062b\u0627\u0646\u06cc\u0647 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u0646\u062f\u060c \u0628\u0633\u06cc\u0627\u0631 \u0645\u0646\u0627\u0633\u0628 \u0628\u0627\u0634\u062f.<\/p>\n

\u0632\u0628\u0627\u0646 \u06a9\u0648\u0626\u0631\u06cc ClickHouse \u0646\u0648\u0639\u06cc Dialect \u0627\u0632 SQL \u0627\u0633\u062a \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646 \u0646\u0648\u0634\u062a\u0646 \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc Declarative \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u062f\u0631 \u0639\u06cc\u0646 \u062d\u0627\u0644 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0622\u0634\u0646\u0627 \u0628\u0627 SQL\u060c \u0645\u0646\u062d\u0646\u06cc \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u06a9\u0648\u062a\u0627\u0647\u06cc \u062f\u0627\u0631\u062f.<\/p>\n

\n

\u062a\u0641\u0627\u0648\u062a \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0633\u062a\u0648\u0646\u200c\u0645\u062d\u0648\u0631 \u0628\u0627 \u0633\u0637\u0631\u06cc<\/h2>\n

\u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc Column-Oriented\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0633\u062a\u0648\u0646\u200c\u0647\u0627<\/strong> \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u0646\u0647 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627.<\/p>\n

\u0645\u0632\u06cc\u062a \u0627\u0635\u0644\u06cc \u0627\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0647\u0646\u06af\u0627\u0645 \u0627\u062c\u0631\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc\u060c \u0641\u0642\u0637 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0645\u0648\u0631\u062f\u0646\u06cc\u0627\u0632 \u062e\u0648\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646:<\/p>\n

    \n
  • \n

    \u062f\u0627\u062f\u0647 \u06a9\u0645\u062a\u0631\u06cc \u0627\u0632 \u062f\u06cc\u0633\u06a9 \u062e\u0648\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f<\/p>\n<\/li>\n

  • \n

    \u0633\u0631\u0639\u062a \u067e\u0631\u062f\u0627\u0632\u0634 \u0627\u0641\u0632\u0627\u06cc\u0634 \u067e\u06cc\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u062f<\/p>\n<\/li>\n

  • \n

    \u0628\u0631\u0627\u06cc workload\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644\u06cc \u0645\u062b\u0644 OLAP \u0628\u0633\u06cc\u0627\u0631 \u0633\u0631\u06cc\u0639\u200c\u062a\u0631 \u0627\u0632 \u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627\u06cc Row-Based \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f<\/p>\n<\/li>\n<\/ul>\n

    \n

    OLAP \u0686\u06cc\u0633\u062a\u061f<\/h2>\n

    \u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627\u06cc Online Analytical Processing (OLAP)<\/strong> \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062d\u062c\u0645 \u0639\u0638\u06cc\u0645\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0637\u0631\u0627\u062d\u06cc \u0634\u062f\u0647\u200c\u0627\u0646\u062f \u0648 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0631\u0627 \u0628\u0627 \u0633\u0631\u0639\u062a \u0628\u0627\u0644\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u0646\u062f.<\/p>\n

    \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627:<\/p>\n

      \n
    • \n

      \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0627\u062f\u0647 \u062f\u0631 \u0645\u0642\u06cc\u0627\u0633 \u067e\u062a\u0627\u0628\u0627\u06cc\u062a<\/p>\n<\/li>\n

    • \n

      \u067e\u0627\u0633\u062e\u200c\u062f\u0647\u06cc \u0633\u0631\u06cc\u0639 \u0628\u0647 \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644\u06cc<\/p>\n<\/li>\n

    • \n

      \u0645\u0646\u0627\u0633\u0628 \u0628\u0631\u0627\u06cc Data Science \u0648 Business Analytics<\/p>\n<\/li>\n<\/ul>\n

      \n

      \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0686\u0647 \u0645\u06cc\u200c\u0622\u0645\u0648\u0632\u06cc\u062f\u061f<\/h2>\n

      \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627 \u0634\u0645\u0627:<\/p>\n

        \n
      • \n

        ClickHouse Server \u0648 Client \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f<\/p>\n<\/li>\n

      • \n

        \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648 \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f<\/p>\n<\/li>\n

      • \n

        \u062f\u0627\u062f\u0647 \u062f\u0631\u062c\u060c \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0648 \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f<\/p>\n<\/li>\n

      • \n

        \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644\u06cc \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f<\/p>\n<\/li>\n

      • \n

        \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u06cc\u0645\u0648\u062a \u0631\u0627 \u0641\u0639\u0627\u0644 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f<\/p>\n<\/li>\n

      • \n

        \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f<\/p>\n<\/li>\n<\/ul>\n

        \n

        \u0645\u0631\u062d\u0644\u0647 \u06f1 \u2014 \u0646\u0635\u0628 ClickHouse<\/h1>\n

        \u0627\u0628\u062a\u062f\u0627 \u0648\u0627\u0631\u062f \u0633\u0631\u0648\u0631 \u0634\u0648\u06cc\u062f:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        ssh<\/span> sammy@your_server_ip<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u06a9\u0644\u06cc\u062f GPG \u0645\u062e\u0632\u0646 Yandex \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        sudo<\/span> apt-key adv –keyserver<\/span> keyserver.ubuntu.com –recv<\/span> E0C56BD4<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0645\u062e\u0632\u0646 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        echo<\/span> “deb http:\/\/repo.yandex.ru\/clickhouse\/deb\/stable\/ main\/”<\/span> | sudo<\/span> tee<\/span> \/etc\/apt\/sources.list.d\/clickhouse.list<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0628\u0633\u062a\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        sudo<\/span> apt update<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0646\u0635\u0628 \u0633\u0631\u0648\u0631 \u0648 \u06a9\u0644\u0627\u06cc\u0646\u062a:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        sudo<\/span> apt install clickhouse-server clickhouse-client<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u062f\u0631 \u0647\u0646\u06af\u0627\u0645 \u0646\u0635\u0628\u060c \u0627\u0632 \u0634\u0645\u0627 \u062e\u0648\u0627\u0633\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n

        \n

        \u0645\u0631\u062d\u0644\u0647 \u06f2 \u2014 \u0627\u062c\u0631\u0627\u06cc \u0633\u0631\u0648\u06cc\u0633<\/h1>\n

        \u0634\u0631\u0648\u0639 \u0633\u0631\u0648\u06cc\u0633:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        sudo<\/span> service<\/span> clickhouse-server start<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0628\u0631\u0631\u0633\u06cc \u0648\u0636\u0639\u06cc\u062a:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        sudo<\/span> service<\/span> clickhouse-server status<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0627\u06af\u0631 Active: active (running) \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0631\u062f\u06cc\u062f \u06cc\u0639\u0646\u06cc \u0633\u0631\u0648\u06cc\u0633 \u0641\u0639\u0627\u0644 \u0627\u0633\u062a.<\/p>\n

        \n

        \u0645\u0631\u062d\u0644\u0647 \u06f3 \u2014 \u0633\u0627\u062e\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648 \u062c\u062f\u0648\u0644<\/h1>\n

        \u0648\u0631\u0648\u062f \u0628\u0647 \u06a9\u0644\u0627\u06cc\u0646\u062a:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        clickhouse-client –password<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0633\u0627\u062e\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        CREATE<\/span> DATABASE test;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        USE test;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644 visits:<\/p>\n

        \n
        \n
        \n
        \n
        \n
        \n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        <\/div>\n<\/div>\n<\/div>\n
        \n
        \n
        \n
        \n
        CREATE<\/span> TABLE<\/span> visits (
        \nid UInt64,
        \nduration Float64,
        \nurl String,
        \ncreated DateTime
        \n) ENGINE =<\/span> MergeTree()
        \nPRIMARY<\/span> KEY<\/span> id
        \nORDER<\/span> BY<\/span> id;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
        \n
        <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

        \u062a\u0648\u0636\u06cc\u062d \u0646\u0648\u0639 \u062f\u0627\u062f\u0647\u200c\u0647\u0627<\/h3>\n