{"id":31114,"date":"2019-07-29T16:52:16","date_gmt":"2019-07-29T21:52:16","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=31114"},"modified":"2022-06-03T03:33:37","modified_gmt":"2022-06-03T08:33:37","slug":"how-to-install-clickhouse-on-centos-7","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/","title":{"rendered":"How to Install ClickHouse on CentOS 7"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-31274\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.jpg\" alt=\"\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this tutorial, we will show you how to install ClickHouse on a <a href=\"https:\/\/www.rosehosting.com\/centos-hosting.html\">CentOS 7 VPS<\/a>, as well as demonstrate some things that you can do in ClickHouse.<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-31275\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/managed-clickhouse-centos-vps.jpg\" alt=\"\" width=\"200\" height=\"100\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/managed-clickhouse-centos-vps.jpg 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/managed-clickhouse-centos-vps-150x75.jpg 150w\" sizes=\"(max-width: 200px) 100vw, 200px\" \/>ClickHouse is a distributed analytical column-oriented database management system. ClickHouse has the ability to perform queries in real-time, making it simple and easy to run applications that require analytical results. The ClickHouse query language is based on SQL, which only helps to simplify and reduce the learning curve for the end user. ClickHouse has two main characteristics:<\/p>\n<ul>\n<li><em>Column-oriented databases \u2013\u00a0<\/em>Records in blocks grouped by columns instead of rows. This method is much faster than the traditional row-based system.<\/li>\n<li><em>Online Analytics Processing system<\/em>\u00a0\u2013 This systems allows for the organization of a large amount of data, as well as executing more complex queries.<\/li>\n<\/ul>\n<p>Let&#8217;s get started with the installation.<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69f1e289080e9\" 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-69f1e289080e9\"  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-centos-7\/#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-centos-7\/#Step-1-Connect-via-SSH-and-Update\" >Step 1: Connect via SSH and Update<\/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-centos-7\/#Step-2-Install-ClickHouse\" >Step 2: Install ClickHouse<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#Step-3-Starting-the-ClickHouse-Service\" >Step 3: Starting the ClickHouse Service\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#Step-4-Creating-Databases-and-Tables\" >Step 4: Creating Databases and Tables<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span><strong>Prerequisites<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>For the purposes of this tutorial, we will use a <a href=\"https:\/\/www.rosehosting.com\/centos-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">CentOS 7 VPS<\/a>.<\/li>\n<li>Full SSH root access or a user with sudo privileges is also required.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Connect-via-SSH-and-Update\"><\/span><span id=\"1-Connect-via-SSH\" class=\"ez-toc-section\">Step 1: Connect via SSH and Update<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Connect to your server via SSH as the root user using the following command:<\/p>\n<pre>ssh root@<span style=\"color: #ff0000;\">IP_ADDRESS<\/span> -p <span style=\"color: #ff0000;\">PORT_NUMBER<\/span><\/pre>\n<p>Remember to replace \u201c<span style=\"color: #ff0000;\">IP_ADDRESS<\/span>\u201d and \u201c<span style=\"color: #ff0000;\">PORT_NUMBER<\/span>\u201d with your server&#8217;s respective IP address and SSH port number.<\/p>\n<p>Before starting with the installation, you will need to update your system packages to their latest versions. It&#8217;s easy to do, and it won&#8217;t take more than a few minutes.<\/p>\n<p>You can do this by running the following command:<\/p>\n<pre>sudo yum update<\/pre>\n<p>Once the updates are completed, we can move on to the next step.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-ClickHouse\"><\/span><span id=\"2-Install-Redis-on-Ubuntu-1604\" class=\"ez-toc-section\">Step 2: Install ClickHouse<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>We will install the ClickHouse server and client programs using the\u00a0<em>YUM package manager<\/em>. First, we need to install the ClickHouse dependencies. We&#8217;re installing the &#8216;<em>pygpgme<\/em>&#8216; package, which is used for adding and verifying GPG signatures.<\/p>\n<pre>sudo yum install pygpgme yum-utils<\/pre>\n<p>The built-in preinstalled repositories on CentOS unfortunately do not contain the latest version of ClickHouse &#8211; this is why we&#8217;ll be installing a repository that has the latest version for CentOS. Before installing this repository, we will first need to add some repository details which will secure and validate our ClickHouse packages.<\/p>\n<p>For this tutorial, we&#8217;ll be using &#8216;vi&#8217; as our text editor of choice. You are free to use your preferred text editor if you like. We will now create the repository file by using the following command:<\/p>\n<pre>sudo vi \/etc\/yum.repos.d\/altinity_clickhouse.repo<\/pre>\n<p>Next, we will add the following content to the file:<\/p>\n<pre>[altinity_clickhouse]\r\nname=altinity_clickhouse\r\nbaseurl=https:\/\/packagecloud.io\/altinity\/clickhouse\/el\/7\/$basearch\r\nrepo_gpgcheck=1\r\ngpgcheck=0\r\nenabled=1\r\ngpgkey=https:\/\/packagecloud.io\/altinity\/clickhouse\/gpgkey\r\nsslverify=1\r\nsslcacert=\/etc\/pki\/tls\/certs\/ca-bundle.crt\r\nmetadata_expire=300\r\n\r\n[altinity_clickhouse-source]\r\nname=altinity_clickhouse-source\r\nbaseurl=https:\/\/packagecloud.io\/altinity\/clickhouse\/el\/7\/SRPMS\r\nrepo_gpgcheck=1\r\ngpgcheck=0\r\nenabled=1\r\ngpgkey=https:\/\/packagecloud.io\/altinity\/clickhouse\/gpgkey\r\nsslverify=1\r\nsslcacert=\/etc\/pki\/tls\/certs\/ca-bundle.crt\r\nmetadata_expire=300<\/pre>\n<p>When you are finished with adding the text, save and close the file.<\/p>\n<p>Once you have added the repositories, you&#8217;ll need to enable them by executing the following command:<\/p>\n<pre>sudo yum -q makecache -y --disablerepo='*' --enablerepo='altinity_clickhouse'<\/pre>\n<p>You should see an output similar to the following:<\/p>\n<pre>Importing GPG key 0x0C7EG6F3:\r\nUserid : \"https:\/\/packagecloud.io\/altinity\/clickhouse\u00a0 &lt;support@packagecloud.io&gt;\"\r\nFingerprint: 6102 38a9 7c50 3h82 28bf 3f16 wg56 5vf3 0f6g 8df2\r\nFrom : https:\/\/packagecloud.io\/altinity\/clickhouse\/gpgkey<\/pre>\n<p>After successfully configuring the repository, we will be able to install the packages with the following command:<\/p>\n<pre>sudo yum install -y clickhouse-server clickhouse-client<\/pre>\n<p>The ClickHouse server and client have been installed successfully.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Starting-the-ClickHouse-Service\"><\/span><span id=\"2-Install-Redis-on-Ubuntu-1604\" class=\"ez-toc-section\">Step 3: Starting the ClickHouse Service\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The ClickHouse package creates a systemd service during the installation process. This is so that we are able to perform actions regarding ClickHouse such as starting, stopping, and restarting the database server. We can start our ClickHouse server by running the following command:<\/p>\n<pre>sudo service clickhouse-server start<\/pre>\n<p>You should see an output similar to this:<\/p>\n<pre>Start clickhouse-server service: Path to data directory in \/etc\/clickhouse-server\/config.xml: \/var\/lib\/clickhouse\/\r\nDONE<\/pre>\n<p>If you want to check that the service is running successfully, we need to execute this:<\/p>\n<pre>sudo service clickhouse-server status<\/pre>\n<p>If everything is set up properly, you should see an output similar to the following:<\/p>\n<pre>clickhouse-server service is running<\/pre>\n<p>If that&#8217;s the message returned by the command, then we have successfully installed and started our ClickHouse server, and now we will be able to use and connect to the ClickHouse CLI.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Creating-Databases-and-Tables\"><\/span><span id=\"2-Install-Redis-on-Ubuntu-1604\" class=\"ez-toc-section\">Step 4: Creating Databases and Tables<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To create a database, we need to start a client session by executing the following command:<\/p>\n<pre>clickhouse-client --multiline<\/pre>\n<p>The multiline flag allows us to enter queries that span multiple lines.<\/p>\n<p>Now we will create a database named &#8216;<em>test<\/em>&#8216;, inside of which we will then create a table named &#8216;<em>person<\/em>&#8216;.<\/p>\n<p>Since we are already inside the ClickHouse command prompt, we can create our test database with the following command:<\/p>\n<pre>ch:) CREATE DATABASE test;<\/pre>\n<p>You should see the output similar to this:<\/p>\n<pre>CREATE DATABASE test\r\nOk.\r\n0 rows in set. Elapsed: 0.005 sec.<\/pre>\n<p>Before we create a table, we first need to enter the database that we will be modifying:<\/p>\n<pre>ch:) USE <span class=\"highlight\">test<\/span>;<\/pre>\n<p>You will see the output which will show you that you have switched to the <em>test<\/em> database:<\/p>\n<pre>USE test\r\nOk.\r\n0 rows in set. Elapsed: 0.003 sec.<\/pre>\n<p>Our &#8216;person&#8217; table will have several fields, such as &#8216;PersonID&#8217;, &#8216;LastName&#8217;, &#8216;FirstName&#8217;, and so on.<\/p>\n<p>Now we can create the <em>person<\/em> table by running the following command:<\/p>\n<pre>ch:) CREATE TABLE Person (\r\nch:) PersonID UInt64,\r\nch:) LastName String,\r\nch:) FirstName String,\r\nch:) Address String,\r\nch:) City String,\r\nch:) BirthDate DateTime\r\nch:) ) ENGINE = MergeTree() \r\nch:) PRIMARY KEY PersonID \r\nch:) ORDER BY PersonID;<\/pre>\n<p>If everything is created properly, you should see the following output:<\/p>\n<pre>CREATE TABLE Person\r\n(\r\nPersonID UInt64,\r\nLastName String,\r\nFirstName String,\r\nAddress String,\r\nCity String,\r\nBirthDate DateTime\r\n)\r\nENGINE = MergeTree()\r\nPRIMARY KEY PersonID\r\nORDER BY PersonID\r\n\r\nOk.\r\n\r\n0 rows in set. Elapsed: 0.015 sec.<\/pre>\n<p>That&#8217;s all there is to it &#8211; in this tutorial, we learned how to install ClickHouse on CentOS 7, as well as how to create sample databases and tables. Of course, there are a lot more capabilities in ClickHouse that we haven&#8217;t covered. This is why we suggest reading the documentation in order to fulfill the server&#8217;s full potential.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-31276\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/clickhouse-centos7-example.jpg\" alt=\"\" width=\"100\" height=\"100\" \/>Of course, you don\u2019t have to install ClickHouse on <a href=\"https:\/\/www.rosehosting.com\/centos-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">CentOS 7<\/a> if you use one of our <a href=\"https:\/\/www.rosehosting.com\/centos-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Managed CentOS Hosting services<\/a>, in which case you can simply ask our expert system administrators to install ClickHouse on CentOS 7 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p><span style=\"color: #ff0000;\">PS.<\/span> If you liked this post on how to install ClickHouse on CentOS 7, 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 show you how to install ClickHouse on a CentOS 7 VPS, as well as demonstrate &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install ClickHouse on CentOS 7\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#more-31114\" aria-label=\"Read more about How to Install ClickHouse on CentOS 7\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":31274,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1699,1702,1711],"tags":[541,1824],"class_list":["post-31114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-databases","category-e-commerce","tag-centos-7","tag-install-clickhouse","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install ClickHouse on CentOS 7 | RoseHosting<\/title>\n<meta name=\"description\" content=\"How to Install ClickHouse on CentOS 7 | 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-centos-7\/\" \/>\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 CentOS 7\" \/>\n<meta property=\"og:description\" content=\"How to Install ClickHouse on CentOS 7 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/\" \/>\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-07-29T21:52:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:33:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.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=\"6 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-centos-7\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install ClickHouse on CentOS 7\",\"datePublished\":\"2019-07-29T21:52:16+00:00\",\"dateModified\":\"2022-06-03T08:33:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/\"},\"wordCount\":887,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-clickhouse-on-centos7.jpg\",\"keywords\":[\"centos 7\",\"Install ClickHouse\"],\"articleSection\":[\"CentOS\",\"Databases\",\"E-Commerce\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/\",\"name\":\"How to Install ClickHouse on CentOS 7 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-clickhouse-on-centos7.jpg\",\"datePublished\":\"2019-07-29T21:52:16+00:00\",\"dateModified\":\"2022-06-03T08:33:37+00:00\",\"description\":\"How to Install ClickHouse on CentOS 7 | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-clickhouse-on-centos7.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-clickhouse-on-centos7.jpg\",\"width\":742,\"height\":372},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-clickhouse-on-centos-7\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install ClickHouse on CentOS 7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"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\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"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\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?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 Premium plugin. -->","yoast_head_json":{"title":"How to Install ClickHouse on CentOS 7 | RoseHosting","description":"How to Install ClickHouse on CentOS 7 | 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-centos-7\/","og_locale":"en_US","og_type":"article","og_title":"How to Install ClickHouse on CentOS 7","og_description":"How to Install ClickHouse on CentOS 7 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2019-07-29T21:52:16+00:00","article_modified_time":"2022-06-03T08:33:37+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install ClickHouse on CentOS 7","datePublished":"2019-07-29T21:52:16+00:00","dateModified":"2022-06-03T08:33:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/"},"wordCount":887,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.jpg","keywords":["centos 7","Install ClickHouse"],"articleSection":["CentOS","Databases","E-Commerce"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/","name":"How to Install ClickHouse on CentOS 7 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.jpg","datePublished":"2019-07-29T21:52:16+00:00","dateModified":"2022-06-03T08:33:37+00:00","description":"How to Install ClickHouse on CentOS 7 | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-clickhouse-on-centos7.jpg","width":742,"height":372},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-clickhouse-on-centos-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install ClickHouse on CentOS 7"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","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":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"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\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?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\/31114","targetHints":{"allow":["GET"]}}],"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=31114"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31114\/revisions"}],"predecessor-version":[{"id":41711,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31114\/revisions\/41711"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/31274"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=31114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=31114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=31114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}