{"id":1261,"date":"2020-09-09T14:10:25","date_gmt":"2020-09-09T19:10:25","guid":{"rendered":"https:\/\/linuxhostsupport.com\/blog\/?p=1261"},"modified":"2020-09-09T14:10:25","modified_gmt":"2020-09-09T19:10:25","slug":"how-to-install-clickhouse-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","title":{"rendered":"How to Install ClickHouse on Ubuntu 18.04"},"content":{"rendered":"<div id=\"linux-3407465017\" class=\"linux-before-1st-paragraph linux-entity-placement\" style=\"margin-top: 15px;margin-bottom: 15px;\"><a href=\"https:\/\/www.rosehosting.com\/managed-vps-hosting\/?mtm_campaign=blogs&#038;mtm_source=lhs&#038;mtm_medium=blog&#038;mtm_content=managed-vps&#038;mtm_cid=1339&#038;mtm_placement=inline\" aria-label=\"Untitled\"><img src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340090_NVMeGoogleAds_728x90_041322.jpg\" alt=\"\"  srcset=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340090_NVMeGoogleAds_728x90_041322.jpg 728w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340090_NVMeGoogleAds_728x90_041322-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" width=\"728\" height=\"90\"  style=\"display: inline-block;\" \/><\/a><\/div><p>ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries while including high-availability features that work across clusters. If you are looking for a powerful column oriented database system with a high-availability system, you really should consider ClickHouse as your database system of choice.<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-1266\" src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/install-clickhouse-database-system-on-ubuntu-18-04-server-vps.jpg\" alt=\"\" width=\"115\" height=\"115\" srcset=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/install-clickhouse-database-system-on-ubuntu-18-04-server-vps.jpg 115w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/install-clickhouse-database-system-on-ubuntu-18-04-server-vps-60x60.jpg 60w\" sizes=\"(max-width: 115px) 100vw, 115px\" \/>ClickHouse also provides multi-master synchronous replication, automatic fail-over, and self-organizing clusters. All in all, this makes ClickHouse a great choice for most users that need analytic features from their database system.<\/p>\n<p>In this tutorial, we will show you how to install ClickHouse on an Ubuntu 18.04 server.<\/p>\n<p><!--more--><\/p>\n<h2>Prerequisites<\/h2>\n<ul>\n<li>Ubuntu 18.04 server or VPS. Other Ubuntu versions may work, but this tutorial is focused on Ubuntu 18.04.<\/li>\n<li>SSH access with root privileges (a user account that has sudo access or the root account)<\/li>\n<\/ul>\n<h2>Step 1 &#8211; Getting Started &#8211; Login &amp; Updates<\/h2>\n<p>Log in to your Ubuntu 18.04 VPS using SSH as the root user (or as a user that has sudo privileges)<\/p>\n<pre>ssh root@IP_Address -p Port_number<\/pre>\n<p>Don&#8217;t forget to replace <code>IP_Address<\/code> and <code>Port_number<\/code> with their respective values for your server. If you don&#8217;t know your server&#8217;s SSH port, it&#8217;s likely port 22.<\/p>\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>Again, if you have Ubuntu 16.04 or Ubuntu 20.04, this may work, but it&#8217;s not guaranteed.<\/p>\n<p>Then, run the following command to make sure that all installed packages on the server are updated to the latest available version.<\/p>\n<pre># apt update &amp;&amp; apt upgrade<\/pre>\n<p>This maximizes compatibility and ensures that nothing is out of date.<\/p>\n<h2>Step 2 &#8211; Install ClickHouse<\/h2>\n<p>There are several ways to install ClickHouse on Ubuntu 18.04 (such as building it from source), but in this tutorial, we will install it using the ClickHouse official repository. This simplifies the install and gets you up and running in just a few minutes. You can add the key for the repository and then install the repository with these commands:<\/p>\n<pre># apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4\r\n# echo \"deb http:\/\/repo.yandex.ru\/clickhouse\/deb\/stable\/ main\/\" | 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 user &#8216;default&#8217;. Please create and save a copy of the password &#8211; you will need it to access your ClickHouse server.<\/p>\n<p>Once the installation is completed, we can enable ClickHouse to run automatically on boot.<\/p>\n<pre># systemctl enable clickhouse-server<\/pre>\n<p>Let&#8217;s start the ClickHouse service now.<\/p>\n<pre># systemctl start clickhouse-server<\/pre>\n<p>Your ClickHouse server is now running, you can verify it by running this command:<\/p>\n<pre># systemctl status clickhouse-server<\/pre>\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 that the server is running, 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 that 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<\/pre>\n<p>Here&#8217;s how you can show your databases in ClickHouse:<\/p>\n<pre>ubuntu1804.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<\/pre>\n<p>And here&#8217;s how you can select using ClickHouse.<\/p>\n<pre>ubuntu1804.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 problems.<\/p>\n<h2>Step 3 &#8211; Configure ClickHouse<\/h2>\n<h3>3.1 &#8211; Change listening IP address<\/h3>\n<p>Once the 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 tag 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 that 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 same <code>config.xml<\/code> file as before. If you choose not to do this, you won&#8217;t 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>, then uncomment the tag 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-1262\" src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/tabix_home-1024x449-2.png\" alt=\"\" width=\"1024\" height=\"449\" srcset=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/tabix_home-1024x449-2.png 1024w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/tabix_home-1024x449-2-300x132.png 300w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/tabix_home-1024x449-2-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 using 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-1267\" src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/ultimate-premium-clickhouse-managed-support-by-experts-for-linux-servers.jpg\" alt=\"\" width=\"115\" height=\"115\" srcset=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/ultimate-premium-clickhouse-managed-support-by-experts-for-linux-servers.jpg 115w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/ultimate-premium-clickhouse-managed-support-by-experts-for-linux-servers-60x60.jpg 60w\" sizes=\"(max-width: 115px) 100vw, 115px\" \/>Setting up ClickHouse is easy, but maintaining it is a different story. This is where our <a href=\"https:\/\/linuxhostsupport.com\/monthly-server-management.html\">Managed Ubuntu Support<\/a> services can help you save a lot of time and money when running your business. We specialize in fully-managed support for almost any enterprise Linux server. Whether you need help optimizing your ClickHouse instance, or general maintenance and management of any other service, we&#8217;re here to help you 24 hours a day, 7 days a week.<\/p>\n<p>If you found this tutorial helpful in setting up ClickHouse on your Ubuntu server, please consider sharing this post on social media with our share shortcuts, or leave a comment telling us how the install went in our comments section. Thanks.<\/p><div id=\"linux-1741192375\" class=\"linux-after-8th-paragraph linux-entity-placement\" style=\"margin-top: 15px;margin-bottom: 15px;\"><a href=\"https:\/\/www.rosehosting.com\/managed-vps-hosting\/?mtm_campaign=blogs&#038;mtm_source=lhs&#038;mtm_medium=blog&#038;mtm_content=managed-vps&#038;mtm_cid=1340&#038;mtm_placement=inline\" aria-label=\"Untitled\"><img src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340095_VPSGoogleAds_728x90_042622.jpg\" alt=\"\"  srcset=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340095_VPSGoogleAds_728x90_042622.jpg 728w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340095_VPSGoogleAds_728x90_042622-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" width=\"728\" height=\"90\"  style=\"display: inline-block;\" \/><\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries while including high-availability features that work across clusters. If you are looking for a powerful column oriented database system with a high-availability system, you really should consider ClickHouse as your database system of choice. ClickHouse [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1265,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[165,166,20],"class_list":["post-1261","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-clickhouse","tag-databases","tag-ubuntu"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Install ClickHouse on Ubuntu 18.04 | LinuxHostSupport<\/title>\n<meta name=\"description\" content=\"ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linuxhostsupport.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 | LinuxHostSupport\" \/>\n<meta property=\"og:description\" content=\"ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"LinuxHostSupport\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/linuxhostsupport\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-09T19:10:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/how-to-install-clickhouse-on-ubuntu-18-04.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\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=\"@lnxhostsupport\" \/>\n<meta name=\"twitter:site\" content=\"@lnxhostsupport\" \/>\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:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#\\\/schema\\\/person\\\/53a9571ea078cdf350137a1e97423cfb\"},\"headline\":\"How to Install ClickHouse on Ubuntu 18.04\",\"datePublished\":\"2020-09-09T19:10:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\"},\"wordCount\":813,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/how-to-install-clickhouse-on-ubuntu-18-04.jpg\",\"keywords\":[\"clickhouse\",\"databases\",\"ubuntu\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\",\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\",\"name\":\"How to Install ClickHouse on Ubuntu 18.04 | LinuxHostSupport\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/how-to-install-clickhouse-on-ubuntu-18-04.jpg\",\"datePublished\":\"2020-09-09T19:10:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#\\\/schema\\\/person\\\/53a9571ea078cdf350137a1e97423cfb\"},\"description\":\"ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/how-to-install-clickhouse-on-ubuntu-18-04.jpg\",\"contentUrl\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/08\\\/how-to-install-clickhouse-on-ubuntu-18-04.jpg\",\"width\":750,\"height\":410},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-18-04\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install ClickHouse on Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/\",\"name\":\"LinuxHostSupport\",\"description\":\"Linux Tutorials and Guides\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#\\\/schema\\\/person\\\/53a9571ea078cdf350137a1e97423cfb\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/author\\\/r0s3admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install ClickHouse on Ubuntu 18.04 | LinuxHostSupport","description":"ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries","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:\/\/linuxhostsupport.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 | LinuxHostSupport","og_description":"ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries","og_url":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","og_site_name":"LinuxHostSupport","article_publisher":"https:\/\/www.facebook.com\/linuxhostsupport","article_published_time":"2020-09-09T19:10:25+00:00","og_image":[{"width":750,"height":410,"url":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/how-to-install-clickhouse-on-ubuntu-18-04.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@lnxhostsupport","twitter_site":"@lnxhostsupport","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#article","isPartOf":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/"},"author":{"name":"admin","@id":"https:\/\/linuxhostsupport.com\/blog\/#\/schema\/person\/53a9571ea078cdf350137a1e97423cfb"},"headline":"How to Install ClickHouse on Ubuntu 18.04","datePublished":"2020-09-09T19:10:25+00:00","mainEntityOfPage":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/"},"wordCount":813,"commentCount":0,"image":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/how-to-install-clickhouse-on-ubuntu-18-04.jpg","keywords":["clickhouse","databases","ubuntu"],"articleSection":["Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","url":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/","name":"How to Install ClickHouse on Ubuntu 18.04 | LinuxHostSupport","isPartOf":{"@id":"https:\/\/linuxhostsupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage"},"image":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/how-to-install-clickhouse-on-ubuntu-18-04.jpg","datePublished":"2020-09-09T19:10:25+00:00","author":{"@id":"https:\/\/linuxhostsupport.com\/blog\/#\/schema\/person\/53a9571ea078cdf350137a1e97423cfb"},"description":"ClickHouse is a fast and open source column-oriented analytics database system developed by Yandex. ClickHouse\u00a0is built to process analytical queries","breadcrumb":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#primaryimage","url":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/how-to-install-clickhouse-on-ubuntu-18-04.jpg","contentUrl":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/08\/how-to-install-clickhouse-on-ubuntu-18-04.jpg","width":750,"height":410},{"@type":"BreadcrumbList","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-install-clickhouse-on-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/linuxhostsupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install ClickHouse on Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/linuxhostsupport.com\/blog\/#website","url":"https:\/\/linuxhostsupport.com\/blog\/","name":"LinuxHostSupport","description":"Linux Tutorials and Guides","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxhostsupport.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/linuxhostsupport.com\/blog\/#\/schema\/person\/53a9571ea078cdf350137a1e97423cfb","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/linuxhostsupport.com\/blog\/author\/r0s3admin\/"}]}},"_links":{"self":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts\/1261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/comments?post=1261"}],"version-history":[{"count":4,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts\/1261\/revisions"}],"predecessor-version":[{"id":1273,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts\/1261\/revisions\/1273"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/media\/1265"}],"wp:attachment":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/media?parent=1261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/categories?post=1261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/tags?post=1261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}