{"id":31286,"date":"2019-11-15T15:12:14","date_gmt":"2019-11-15T21:12:14","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=31286"},"modified":"2022-06-03T03:33:19","modified_gmt":"2022-06-03T08:33:19","slug":"how-to-install-clickhouse-on-debian-9","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/","title":{"rendered":"How to Install ClickHouse on Debian 9"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-32128\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg\" alt=\"\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this tutorial, we will explain the steps of installing ClickHouse on a <a href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\">Debian 9 VPS<\/a>.<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-32129\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/configure-clickhouse-database-program-for-debian9-server-vps.jpg\" alt=\"\" width=\"130\" height=\"130\" \/>ClickHouse is a free and open-source DBMS (columnar database management system) developed by Yandex. With ClickHouse, users can manage very large volumes of data, including non-aggregated data, and generate data reports in real time &#8211; and it can do all of this pretty quickly, too. It is able to process hundreds of millions of data entries per second on a server. The system is linearly scalable and can be scaled up to store and process trillions of rows and petabytes of data. \u00a0The installation process is pretty easy and straightforward, and it can be done in less than 10 minutes. Let&#8217;s get started.<!--more--><\/p>\n<p>ClickHouse comes with a lot of useful features. Some of them are listed below:<\/p>\n<ul>\n<li>True Column-Oriented DBMS<\/li>\n<li>Data Compression<\/li>\n<li>Disk Storage of Data<\/li>\n<li>Parallel Processing on Multiple Cores<\/li>\n<li>Distributed Processing on Multiple Servers<\/li>\n<li>SQL Support<\/li>\n<li>Vector Engine<\/li>\n<li>Real-time Data Updates<\/li>\n<li>Suitable for Online Queries<\/li>\n<li>Support for Approximated Calculations<\/li>\n<li>Data replication and data integrity support<\/li>\n<\/ul>\n<p>and much more &#8230;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-663642d68ee0b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-663642d68ee0b\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#Prerequisites\" title=\"Prerequisites\">Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#Step-1-Log-in-and-Update-the-Server\" title=\"Step 1: Log in and Update the Server\">Step 1: Log in and Update the Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#Step-2-Install-ClickHouse\" title=\"Step 2: Install ClickHouse\">Step 2: Install ClickHouse<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>a server or VPS running Debian 9 with SSH access and at least 4 GB of RAM. For the purposes of this tutorial, we will use one of our <a href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\">SSD Debian VPS hosting<\/a> plans (SSD 4 to be exact).<\/li>\n<li>System user with root privileges, or access to the root user. All of our VPS hosting plans come with full root access.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Log-in-and-Update-the-Server\"><\/span>Step 1: Log in and Update the Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In order to start with the ClickHouse installation, we have to log in to the Debian 9 VPS via SSH as the root user.<\/p>\n<pre>ssh root@<span style=\"color: #ff0000;\">IP_address<\/span> -p <span style=\"color: #ff0000;\">Port_number<\/span><\/pre>\n<p>Make sure to replace &#8220;<span style=\"color: #ff0000;\">IP_address<\/span>&#8221; and &#8220;<span style=\"color: #ff0000;\">Port_number<\/span>&#8221; with their respective values for your server.<\/p>\n<p>After you log in, run the following command to make sure that all installed packages on your Debian 9 VPS are updated to their latest available versions:<\/p>\n<pre>apt update &amp;&amp; apt upgrade<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-ClickHouse\"><\/span>Step 2: Install ClickHouse<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>ClickHouse can be installed in several different ways. You can compile the code for your server from the source code, but in this tutorial\u00a0we will guide you through the steps of installing it from Yandex&#8217;s official pre-compiled .deb package. This is the recommended way of installing this application. The first step of the ClickHouse installation is to add Yandex&#8217;s official repository to your server. To do that, create a &#8216;clickhouse.list&#8217; file at the path <code>\/etc\/apt\/sources.list.d\/<\/code> with the following content:<\/p>\n<pre>nano \/etc\/apt\/sources.list.d\/clickhouse.list\r\ndeb http:\/\/repo.yandex.ru\/clickhouse\/deb\/stable\/ main\/<\/pre>\n<p>After you save and exit the file, add the repository key so that you can download the ClickHouse package securely:<\/p>\n<pre>apt-key adv --keyserver hkp:\/\/keyserver.ubuntu.com:80 --recv E0C56BD4<\/pre>\n<p>Once that&#8217;s done, update the repositories list:<\/p>\n<pre>apt update<\/pre>\n<p>Finally, run the following command to install ClickHouse server and client on your Debian 9 VPS:<\/p>\n<pre>apt-get install clickhouse-client clickhouse-server<\/pre>\n<p>We&#8217;re installing both the client and the server, as the client allows you to access and manage the server through the command line.<\/p>\n<p>Once the installation is completed, start the ClickHouse server and enable it to automatically start upon a server reboot:<\/p>\n<pre>systemctl start clickhouse-server\r\nystemctl enable clickhouse-server<\/pre>\n<p>You can check if the ClickHouse server is up and running by checking its status through systemctl:<\/p>\n<pre>systemctl status clickhouse-server<\/pre>\n<p>The output should show that it&#8217;s running, much like the output shows here:<\/p>\n<pre>clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)\r\n   Loaded: loaded (\/etc\/systemd\/system\/clickhouse-server.service; enabled; vendor preset: enabled)\r\n   Active: active (running) since Tue 2019-06-18 12:16:07 EDT; 9s ago\r\n Main PID: 1027 (clickhouse-serv)\r\n    Tasks: 36 (limit: 4915)\r\n   CGroup: \/system.slice\/clickhouse-server.service\r\n           \u00e2\u00e21027 \/usr\/bin\/clickhouse-server --config=\/etc\/clickhouse-server\/config.xml --pid-file=\/run\/clickhouse-server\/clickhouse-server.pid\r\n\r\nJun 18 12:16:07 for-blog-post.rosehostingtest.com systemd[1]: Started ClickHouse Server (analytic DBMS for big data).\r\nJun 18 12:16:07 for-blog-post.rosehostingtest.com clickhouse-server[1027]: Include not found: clickhouse_remote_servers\r\nJun 18 12:16:07 for-blog-post.rosehostingtest.com clickhouse-server[1027]: Include not found: clickhouse_compression\r\nJun 18 12:16:07 for-blog-post.rosehostingtest.com clickhouse-server[1027]: Logging trace to \/var\/log\/clickhouse-server\/clickhouse-server.log\r\nJun 18 12:16:07 for-blog-post.rosehostingtest.com clickhouse-server[1027]: Logging errors to \/var\/log\/clickhouse-server\/clickhouse-server.err.log\r\nJun 18 12:16:07 for-blog-post.rosehostingtest.com clickhouse-server[1027]: Include not found: networks\r\nJun 18 12:16:09 for-blog-post.rosehostingtest.com clickhouse-server[1027]: Include not found: clickhouse_remote_servers\r\nJun 18 12:16:09 for-blog-post.rosehostingtest.com clickhouse-server[1027]: Include not found: clickhouse_compression\r\n<\/pre>\n<p>We have successfully installed the stable release of ClickHouse on the server. To check the version that was installed onto your server, issue the following command:<\/p>\n<pre>clickhouse-server --V\r\nClickHouse server version 19.8.3.8 (official build).<\/pre>\n<p>At the moment of writing this tutorial, it is version 19.8.3.8. If you want to install and use a newer release of ClickHouse, replace <code>stable<\/code> with <code>testing<\/code> in the <code>\/etc\/apt\/sources.list.d\/clickhouse.list<\/code> file. It should look like the following:<\/p>\n<pre>deb http:\/\/repo.yandex.ru\/clickhouse\/deb\/testing\/ main\/<\/pre>\n<p>That&#8217;s all! ClickHouse is now successfully installed on your <a href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\">Debian 9 VPS<\/a> and is ready to use. ClickHouse listens on localhost on port 9000 by default. You can log into the ClickHouse server using the ClickHouse client through the command line interface, as shown below:<\/p>\n<pre>clickhouse-client\r\nClickHouse client version 19.8.3.8 (official build).\r\nConnecting to localhost:9000 as user default.<\/pre>\n<p>If you need more details on ClickHouse or you need to learn how to get started, please visit their official documentation.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-32130\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/assistance-with-setting-up-clickhouse-from-linux-admins-on-debian9-vps.jpg\" alt=\"\" width=\"130\" height=\"130\" \/>Of course, you don\u2019t have to install ClickHouse on Debian 9 if you use one of our <a href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\">Managed Debian Hosting<\/a> services, in which case you can simply ask our expert system administrators to install ClickHouse for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span> If you liked this post on how to install ClickHouse on Debian 9, please share it with your friends on the social networks by using the share shortcuts below, or simply leave a comment in the comments section. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will explain the steps of installing ClickHouse on a Debian 9 VPS. ClickHouse is a free &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install ClickHouse on Debian 9\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#more-31286\" aria-label=\"Read more about How to Install ClickHouse on Debian 9\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":32128,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1700,13],"tags":[1808,48],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install ClickHouse on Debian 9 - RoseHosting<\/title>\n<meta name=\"description\" content=\"How to Install ClickHouse on Debian 9 - RoseHosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install ClickHouse on Debian 9 - RoseHosting\" \/>\n<meta property=\"og:description\" content=\"How to Install ClickHouse on Debian 9 - RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-15T21:12:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:33:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install ClickHouse on Debian 9\",\"datePublished\":\"2019-11-15T21:12:14+00:00\",\"dateModified\":\"2022-06-03T08:33:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/\"},\"wordCount\":718,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg\",\"keywords\":[\"clickhouse\",\"debian\"],\"articleSection\":[\"Debian\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/\",\"name\":\"How to Install ClickHouse on Debian 9 - RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg\",\"datePublished\":\"2019-11-15T21:12:14+00:00\",\"dateModified\":\"2022-06-03T08:33:19+00:00\",\"description\":\"How to Install ClickHouse on Debian 9 - RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg\",\"width\":742,\"height\":372},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install ClickHouse on Debian 9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install ClickHouse on Debian 9 - RoseHosting","description":"How to Install ClickHouse on Debian 9 - RoseHosting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/","og_locale":"en_US","og_type":"article","og_title":"How to Install ClickHouse on Debian 9 - RoseHosting","og_description":"How to Install ClickHouse on Debian 9 - RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2019-11-15T21:12:14+00:00","article_modified_time":"2022-06-03T08:33:19+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install ClickHouse on Debian 9","datePublished":"2019-11-15T21:12:14+00:00","dateModified":"2022-06-03T08:33:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/"},"wordCount":718,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg","keywords":["clickhouse","debian"],"articleSection":["Debian","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/","name":"How to Install ClickHouse on Debian 9 - RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg","datePublished":"2019-11-15T21:12:14+00:00","dateModified":"2022-06-03T08:33:19+00:00","description":"How to Install ClickHouse on Debian 9 - RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-clickhouse-on-debian9.jpg","width":742,"height":372},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-debian-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install ClickHouse on Debian 9"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31286"}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=31286"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31286\/revisions"}],"predecessor-version":[{"id":41685,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31286\/revisions\/41685"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/32128"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=31286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=31286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=31286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}