{"id":1313,"date":"2020-07-24T15:02:49","date_gmt":"2020-07-24T20:02:49","guid":{"rendered":"https:\/\/www.linuxcloudvps.com\/blog\/?p=1313"},"modified":"2020-07-24T15:02:49","modified_gmt":"2020-07-24T20:02:49","slug":"how-to-install-clickhouse-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","title":{"rendered":"How to Install ClickHouse on Ubuntu 18.04"},"content":{"rendered":"<p>In this tutorial, we will show you how to install ClickHouse on an <a href=\"https:\/\/www.linuxcloudvps.com\/cloud-vps.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu 18.04 Cloud VPS<\/a>.<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-1321\" src=\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/set-up-clickhouse-database-system-on-ubuntu-cloud-vps.jpg\" alt=\"\" width=\"120\" height=\"120\" \/>ClickHouse is a fast, open source, column-oriented analytics database system developed by Yandex. ClickHouse was built to process analytical queries that come with high availability features that work across clusters. If you are looking for a powerful column oriented database system with high availability feature, you will want to consider using this. ClickHouse also provides multi-master synchronous replication, automatic fail-over, and a self-organizing cluster. All of these powerful features make for a pretty feature-rich database system. Let&#8217;s get started with the installation of ClickHouse.<\/p>\n<p><!--more--><\/p>\n<h2>Prerequisite<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.linuxcloudvps.com\/cloud-vps.html\">Ubuntu 18.04 Cloud VPS<\/a> (We&#8217;ll be using our LC VPS-2 plan)<\/li>\n<li>SSH access with root privileges (our Cloud VPSes come with root access)<\/li>\n<\/ul>\n<h2>Step 1 &#8211; Log in and Update all Server Packages<\/h2>\n<p>Log in to your Ubuntu 18.04 Cloud VPS with SSH as the root user (or as a user with sudo privileges):<\/p>\n<pre>ssh root@IP_Address -p Port_number<\/pre>\n<p>You can check whether you have the proper Ubuntu version installed on your server with the following command:<\/p>\n<pre># lsb_release -a<\/pre>\n<p>You should get this output:<\/p>\n<pre>Distributor ID: Ubuntu\r\nDescription: Ubuntu 18.04.2 LTS\r\nRelease: 18.04\r\nCodename: bionic<\/pre>\n<p>Then, run the following command to make sure that all installed packages on the server are updated to the latest available versions:<\/p>\n<pre># apt update &amp;&amp; apt upgrade<\/pre>\n<h2>Step 2 &#8211; Install ClickHouse<\/h2>\n<p>There are several ways to install ClickHouse on Ubuntu 18.04, but in this tutorial, we will install it using the official repository for ClickHouse from Yandex.<\/p>\n<pre># apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4\r\n# echo &quot;deb http:\/\/repo.yandex.ru\/clickhouse\/deb\/stable\/ main\/&quot; | tee \/etc\/apt\/sources.list.d\/clickhouse.list<\/pre>\n<p>The command above will create a <code>clickhouse.list<\/code> file. We need to run the following commands to install ClickHouse now.<\/p>\n<pre># apt update\r\n# apt install clickhouse-server clickhouse-client<\/pre>\n<p>In the installation process, you will be asked to create a password for the user <code>default<\/code>. Please create and save a copy of the password, you will need it to access ClickHouse server.<\/p>\n<p>Once the installation has been completed, we can enable ClickHouse to run it on boot.<\/p>\n<pre># systemctl enable clickhouse-server<\/pre>\n<p>Let&#8217;s run the ClickHouse server now.<\/p>\n<pre># systemctl start clickhouse-server<\/pre>\n<p>Your ClickHouse server is now running &#8211; you can verify it by running this command:<\/p>\n<pre># systemctl status clickhouse-server<\/pre>\n<p>It should return output that looks similar to this:<\/p>\n<pre>root@ubuntu1804:~# systemctl status clickhouse-server\r\n\u25cf clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)\r\nLoaded: loaded (\/etc\/systemd\/system\/clickhouse-server.service; enabled; vendor preset: enabled)\r\nActive: active (running) since Mon 2019-07-01 03:37:57 CEST; 3s ago\r\nMain PID: 19308 (clickhouse-serv)\r\nTasks: 36 (limit: 2299)\r\nCGroup: \/system.slice\/clickhouse-server.service\r\n\u2514\u250019308 \/usr\/bin\/clickhouse-server --config=\/etc\/clickhouse-server\/config.xml --pid-file=\/run\/clickhouse-server\/clickhouse-server.pid\r\n\r\nJul 01 03:37:57 ubuntu1804 systemd[1]: Started ClickHouse Server (analytic DBMS for big data).\r\nJul 01 03:37:57 ubuntu1804 clickhouse-server[19308]: Include not found: clickhouse_remote_servers\r\nJul 01 03:37:57 ubuntu1804 clickhouse-server[19308]: Include not found: clickhouse_compression\r\nJul 01 03:37:57 ubuntu1804 clickhouse-server[19308]: Logging trace to \/var\/log\/clickhouse-server\/clickhouse-server.log\r\nJul 01 03:37:57 ubuntu1804 clickhouse-server[19308]: Logging errors to \/var\/log\/clickhouse-server\/clickhouse-server.err.log\r\nJul 01 03:37:57 ubuntu1804 clickhouse-server[19308]: Include not found: networks\r\nJul 01 03:37:59 ubuntu1804 clickhouse-server[19308]: Include not found: clickhouse_remote_servers\r\nJul 01 03:37:59 ubuntu1804 clickhouse-server[19308]: Include not found: clickhouse_compression\r\n<\/pre>\n<p>Now, you can access your ClickHouse server through the command line interface:<\/p>\n<pre># clickhouse-client --password<\/pre>\n<p>You will be asked for the password you created earlier.<\/p>\n<pre>root@ubuntu1804:~# clickhouse-client --password\r\nClickHouse client version 19.9.2.4 (official build).\r\nPassword for user (default):\r\nConnecting to localhost:9000 as user default.\r\nConnected to ClickHouse server version 19.9.2 revision 54421.\r\n\r\nubuntu1804.yourdomain.com :) show databases\r\n\r\nSHOW DATABASES\r\n\r\n\u250c\u2500name\u2500\u2500\u2500\u2500\u2510\r\n\u2502 default \u2502\r\n\u2502 system \u2502\r\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\r\n\r\n2 rows in set. Elapsed: 0.002 sec.\r\n\r\nubuntu1804.yourdomain.com :) select 1\r\n\r\nSELECT 1\r\n\r\n\u250c\u25001\u2500\u2510\r\n\u2502 1 \u2502\r\n\u2514\u2500\u2500\u2500\u2518\r\n\r\n1 rows in set. Elapsed: 0.002 sec.<\/pre>\n<p>As seen above, we can invoke the &#8220;show database&#8221; and &#8220;select&#8221; queries with no issues.<\/p>\n<h2>Step 3 &#8211; Configure ClickHouse<\/h2>\n<p>We can now perform some additional steps to further customize our ClickHouse instance.<\/p>\n<h3>3.1 &#8211; Change the listening IP address<\/h3>\n<p>Once ClickHouse server is installed, you can only access it from the same server, as it only listens on <code>localhost<\/code> by default. To change the listening IP address, we need to edit the <code>\/etc\/clickhouse-server\/config.xml<\/code> file.<\/p>\n<pre># nano \/etc\/clickhouse-server\/config.xml<\/pre>\n<p>Find the string <strong>listen_host<\/strong>, and uncomment the line. If you have several IP addresses and want to set ClickHouse server to listen only on a specific IP address, you can edit the line as follows &#8211; make sure you replace <code>111.222.333.444<\/code> with your actual IP address:<\/p>\n<pre>&lt;listen_host&gt;111.222.333.444&lt;\/listen_host&gt;<\/pre>\n<h3>3.2 &#8211; Enable Tabix<\/h3>\n<p>If you want to access the ClickHouse server through <code>http<\/code> or by using a web browser, you can enable Tabix by editing the <code>config.xml<\/code> file as mentioned before. If you choose not to do this, you will not be able to access and manage your databases through a web browser.<\/p>\n<pre># nano \/etc\/clickhouse-server\/config.xml<\/pre>\n<p>Find the string<strong> http_server_default_response<\/strong> and uncomment the line.<\/p>\n<p>After making changes to the <code>config.xml<\/code> file, we need to restart our <code>clickhouse-server<\/code> service.<\/p>\n<pre># systemctl restart clickhouse-server<\/pre>\n<p>Now, you should be able to access <code>http:\/\/Your_IP_Address:8123<\/code> and log in using the default user and password you specified earlier in the installation process.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1315\" src=\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/tabix_home-1024x449-1.png\" alt=\"\" width=\"1024\" height=\"449\" srcset=\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/tabix_home-1024x449-1.png 1024w, https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/tabix_home-1024x449-1-470x206.png 470w, https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/tabix_home-1024x449-1-970x425.png 970w, https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/tabix_home-1024x449-1-768x337.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Congratulations! At this point, you should be able to access ClickHouse on port 9000 and Tabix at <code>http:\/\/111.222.333.444:8123<\/code>. For more information about ClickHouse, its features, and configuration, please check their official documentation.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-1322\" src=\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/managed-clickhouse-database-system-dbms-full-support-experts-for-ubuntu-cloud-vps.jpg\" alt=\"\" width=\"120\" height=\"120\" \/>Of course, you don\u2019t have to know how to install ClickHouse on Ubuntu 18.04 if you have\u00a0<a href=\"https:\/\/www.linuxcloudvps.com\/cloud-vps.html\">Ubuntu Cloud VPS Hosting<\/a> with us. If you do, installing ClickHouse is as simple as asking our support team to install it for you. They are available 24\/7, and will be able to help you with the installation of ClickHouse on Ubuntu 18.04.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS<\/strong><\/span>. If you enjoyed reading this blog post on <strong>how to install ClickHouse on Ubuntu 18.04<\/strong>, or if you found it helpful feel free to share it on social networks using the shortcuts below, or simply leave a comment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 Cloud VPS. ClickHouse is a fast, open source, column-oriented analytics database system developed by Yandex. ClickHouse was built to process analytical queries that come with high availability features that work across clusters. If you are looking for a powerful column &#8230; <a title=\"How to Install ClickHouse on Ubuntu 18.04\" class=\"read-more\" href=\"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/\" aria-label=\"More on How to Install ClickHouse on Ubuntu 18.04\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1320,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1313","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Install ClickHouse on Ubuntu 18.04 | LinuxCloudVPS Blog<\/title>\n<meta name=\"description\" content=\"In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 Cloud VPS. ClickHouse is a fast, open source, column-oriented analytics\" \/>\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.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/\" \/>\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 Ubuntu 18.04 | LinuxCloudVPS Blog\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 Cloud VPS. ClickHouse is a fast, open source, column-oriented analytics\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"LinuxCloudVPS Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/LinuxCloudVPS\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-24T20:02:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/how-to-install-clickhouse-on-ubuntu18.04.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@LinuxCloudVPS\" \/>\n<meta name=\"twitter:site\" content=\"@LinuxCloudVPS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/person\\\/ed907227ee7d151c617e6d0fe74f531a\"},\"headline\":\"How to Install ClickHouse on Ubuntu 18.04\",\"datePublished\":\"2020-07-24T20:02:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\"},\"wordCount\":693,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/how-to-install-clickhouse-on-ubuntu18.04.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\",\"name\":\"How to Install ClickHouse on Ubuntu 18.04 | LinuxCloudVPS Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/how-to-install-clickhouse-on-ubuntu18.04.jpg\",\"datePublished\":\"2020-07-24T20:02:49+00:00\",\"description\":\"In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 Cloud VPS. ClickHouse is a fast, open source, column-oriented analytics\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/how-to-install-clickhouse-on-ubuntu18.04.jpg\",\"contentUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/how-to-install-clickhouse-on-ubuntu18.04.jpg\",\"width\":750,\"height\":360},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install ClickHouse on Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/\",\"name\":\"LinuxCloudVPS\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#organization\",\"name\":\"LinuxCloudVPS\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/logo.png\",\"width\":217,\"height\":25,\"caption\":\"LinuxCloudVPS\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/www.facebook.com\\\/LinuxCloudVPS\",\"https:\\\/\\\/x.com\\\/LinuxCloudVPS\",\"http:\\\/\\\/www.linkedin.com\\\/company\\\/linuxcloudvps-com\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/person\\\/ed907227ee7d151c617e6d0fe74f531a\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"http:\\\/\\\/www.linuxcloudvps.com\\\/\"],\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/author\\\/r0s3admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install ClickHouse on Ubuntu 18.04 | LinuxCloudVPS Blog","description":"In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 Cloud VPS. ClickHouse is a fast, open source, column-oriented analytics","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.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install ClickHouse on Ubuntu 18.04 | LinuxCloudVPS Blog","og_description":"In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 Cloud VPS. ClickHouse is a fast, open source, column-oriented analytics","og_url":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","og_site_name":"LinuxCloudVPS Blog","article_publisher":"http:\/\/www.facebook.com\/LinuxCloudVPS","article_published_time":"2020-07-24T20:02:49+00:00","og_image":[{"width":750,"height":360,"url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/how-to-install-clickhouse-on-ubuntu18.04.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@LinuxCloudVPS","twitter_site":"@LinuxCloudVPS","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#article","isPartOf":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/"},"author":{"name":"admin","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/person\/ed907227ee7d151c617e6d0fe74f531a"},"headline":"How to Install ClickHouse on Ubuntu 18.04","datePublished":"2020-07-24T20:02:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/"},"wordCount":693,"commentCount":0,"publisher":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/how-to-install-clickhouse-on-ubuntu18.04.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","url":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","name":"How to Install ClickHouse on Ubuntu 18.04 | LinuxCloudVPS Blog","isPartOf":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/how-to-install-clickhouse-on-ubuntu18.04.jpg","datePublished":"2020-07-24T20:02:49+00:00","description":"In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 Cloud VPS. ClickHouse is a fast, open source, column-oriented analytics","breadcrumb":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage","url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/how-to-install-clickhouse-on-ubuntu18.04.jpg","contentUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2020\/07\/how-to-install-clickhouse-on-ubuntu18.04.jpg","width":750,"height":360},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.linuxcloudvps.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install ClickHouse on Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#website","url":"https:\/\/www.linuxcloudvps.com\/blog\/","name":"LinuxCloudVPS","description":"","publisher":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.linuxcloudvps.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#organization","name":"LinuxCloudVPS","url":"https:\/\/www.linuxcloudvps.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2023\/08\/logo.png","contentUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2023\/08\/logo.png","width":217,"height":25,"caption":"LinuxCloudVPS"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/LinuxCloudVPS","https:\/\/x.com\/LinuxCloudVPS","http:\/\/www.linkedin.com\/company\/linuxcloudvps-com"]},{"@type":"Person","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/person\/ed907227ee7d151c617e6d0fe74f531a","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"admin"},"sameAs":["http:\/\/www.linuxcloudvps.com\/"],"url":"https:\/\/www.linuxcloudvps.com\/blog\/author\/r0s3admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/comments?post=1313"}],"version-history":[{"count":6,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1313\/revisions"}],"predecessor-version":[{"id":1513,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1313\/revisions\/1513"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/media\/1320"}],"wp:attachment":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/media?parent=1313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/categories?post=1313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/tags?post=1313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}