{"id":1703,"date":"2022-03-15T12:30:00","date_gmt":"2022-03-15T17:30:00","guid":{"rendered":"https:\/\/www.linuxcloudvps.com\/blog\/?p=1703"},"modified":"2023-08-29T11:17:04","modified_gmt":"2023-08-29T16:17:04","slug":"how-to-install-clickhouse-on-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/","title":{"rendered":"How to Install Clickhouse on Ubuntu 20.04"},"content":{"rendered":"\n<p>ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in real-time and is 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 that can manage large volumes of data, you should consider using ClickHouse as your database system of choice. In this tutorial, we will show you <a href=\"https:\/\/www.linuxcloudvps.com\/ubuntu-cloud-vps.html\">how to install Clickhouse on Ubuntu 20.04<\/a>.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\" id=\"prerequisites\">Prerequisites<\/h2>\n\n\n\n<p>Ubuntu 20.04 VPS<br>SSH root access or a regular system user with sudo privileges<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1-log-in-to-the-server\">Step 1. Log in to the server<\/h2>\n\n\n\n<p>First, log in to your Ubuntu 20.04 server through SSH:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ssh root@IP_Address -p Port_number<\/pre>\n\n\n\n<p>You will need to replace \u2018IP_Address\u2018 and \u2018Port_number\u2018 with your server\u2019s respective IP address and SSH port number. Additionally, replace \u2018root\u2019 with the username of the system user with sudo privileges.<\/p>\n\n\n\n<p>You can check whether you have the proper Ubuntu version installed on your server with the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ lsb_release -a<\/pre>\n\n\n\n<p>You should get this output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">No LSB modules are available.&lt;br&gt;Distributor ID: Ubuntu&lt;br&gt;Description: Ubuntu 20.04.3 LTS&lt;br&gt;Release: 20.04&lt;br&gt;Codename: focal<\/pre>\n\n\n\n<p>Before starting, you have to make sure that all Ubuntu OS packages installed on the server are up to date. You can do this by running the following commands:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt update -y&lt;br&gt;$ sudo apt upgrade -y<\/pre>\n\n\n\n<p>The commands above will download the package lists for your Ubuntu 20.04 VPS. It will update the list of the newest versions of packages and their dependencies available on your system.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2-install-dependencies\">Step 2. Install Dependencies<\/h2>\n\n\n\n<p>The apt-transport package is required to proceed with Clickhouse installation, and it is not installed by default in Ubuntu 20.04. Let&#8217;s run the command below to install it and other required packages.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt install apt-transport-https dirmngr ca-certificates<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3-add-clickhouse-repository\">Step 3. Add Clickhouse Repository<\/h2>\n\n\n\n<p>There are some methods to install ClickHouse on Ubuntu. We can install it from the repository, use docker image, compile it from the source, etc. In this article, we will show you how to install ClickHouse from the repository.<\/p>\n\n\n\n<p>Run the following commands to add the key and its repository.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt-key adv --keyserver hkp:\/\/keyserver.ubuntu.com:80 --recv E0C56BD4<\/pre>\n\n\n\n<p>You will get an output like this if the key is successfully imported:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Executing: \/tmp\/apt-key-gpghome.353DRTy0G9\/gpg.1.sh --keyserver hkp:\/\/keyserver.ubuntu.com:80 --recv E0C56BD4&lt;br&gt;gpg: key C8F1E19FE0C56BD4: public key \"ClickHouse Repository Key &lt;a href=\"mailto:milovidov@yandex-team.ru\"&gt;milovidov@yandex-team.ru&lt;\/a&gt;\" imported&lt;br&gt;gpg: Total number processed: 1&lt;br&gt;gpg: imported: 1<\/pre>\n\n\n\n<p>Then, add the ClickHouse repository<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ echo \"deb https:\/\/repo.clickhouse.com\/deb\/stable\/ main\/\" | sudo tee \/etc\/apt\/sources.list.d\/clickhouse.list<\/pre>\n\n\n\n<p>Do not forget to run an apt update after adding a repository.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt update<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-4-install-clickhouse\">Step 4. Install ClickHouse<\/h2>\n\n\n\n<p>After adding the repository and running the apt update command to download the package list, simply run this command below to install the ClickHouse server and Clickhouse client.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo apt install clickhouse-server clickhouse-client -y<\/pre>\n\n\n\n<p>On Ubuntu 20.04, ClickHouse is configured to start running upon installation, you can check them by running this command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo systemctl status clickhouse-server<\/pre>\n\n\n\n<p>Now, you can connect to clickhouse-server using clickhouse-client. Simply run the command below.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ clickhouse-client<\/pre>\n\n\n\n<p>Invoke the command above then hit ENTER, you will be brought to clickhouse shell, like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ClickHouse client version 18.16.1.\nConnecting to localhost:9000.\nConnected to ClickHouse server version 18.16.1 revision 54412.\n\nubuntu20.rosehosting.com :)<\/pre>\n\n\n\n<p>You can run some queries, like these:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ClickHouse client version 18.16.1.\nConnecting to localhost:9000.\nConnected to ClickHouse server version 18.16.1 revision 54412.\n\nubuntu20.rosehosting.com :) show databases\n\nSHOW DATABASES\n\n\u250c\u2500name\u2500\u2500\u2500\u2500\u2510\n\u2502 default \u2502\n\u2502 system  \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\n2 rows in set. Elapsed: 0.001 sec. \n\nubuntu20.rosehosting.com :) use system\n\nUSE system\n\nOk.\n\n0 rows in set. Elapsed: 0.001 sec. \n\nubuntu20.rosehosting.com :) show tables\n\nSHOW TABLES\n\n\u250c\u2500name\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 aggregate_function_combinators \u2502\n\u2502 asynchronous_metrics           \u2502\n\u2502 build_options                  \u2502\n\u2502 clusters                       \u2502\n\u2502 collations                     \u2502\n\u2502 columns                        \u2502\n\u2502 contributors                   \u2502\n\u2502 data_type_families             \u2502\n\u2502 databases                      \u2502\n\u2502 dictionaries                   \u2502\n\u2502 events                         \u2502\n\u2502 formats                        \u2502\n\u2502 functions                      \u2502\n\u2502 graphite_retentions            \u2502\n\u2502 macros                         \u2502\n\u2502 merge_tree_settings            \u2502\n\u2502 merges                         \u2502\n\u2502 metrics                        \u2502\n\u2502 models                         \u2502\n\u2502 mutations                      \u2502\n\u2502 numbers                        \u2502\n\u2502 numbers_mt                     \u2502\n\u2502 one                            \u2502\n\u2502 parts                          \u2502\n\u2502 parts_columns                  \u2502\n\u2502 processes                      \u2502\n\u2502 replicas                       \u2502\n\u2502 replication_queue              \u2502\n\u2502 settings                       \u2502\n\u2502 table_engines                  \u2502\n\u2502 table_functions                \u2502\n\u2502 tables                         \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\n32 rows in set. Elapsed: 0.002 sec. \n\nubuntu20.rosehosting.com :)<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-5-configure-clickhouse\">Step 5. Configure ClickHouse<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5-1-change-listening-ip-address\">5.1 \u2013 Change listening IP address<\/h3>\n\n\n\n<p>By default, the ClickHouse server listen only on localhost. If you want to access your ClickHouse server from another location, you can modify the configuration file. To change the listening IP address, we need to remove or uncomment the tagline of the &#8220;listen_host&#8221; string in the <code>\/etc\/clickhouse-server\/config.xml<\/code> file.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo nano \/etc\/clickhouse-server\/config.xml<\/pre>\n\n\n\n<p>In that file, find <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">&lt;!-- &lt;listen_host&gt;0.0.0.0&lt;\/listen_host&gt; --&gt;<\/pre>\n\n\n\n<p>and remove uncomment the tag line.<\/p>\n\n\n\n<p>For example, change<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">&lt;!-- &lt;listen_host&gt;0.0.0.0&lt;\/listen_host&gt; --&gt;<\/pre>\n\n\n\n<p>to<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">&lt;listen_host&gt;0.0.0.0&lt;\/listen_host&gt; <\/pre>\n\n\n\n<p>This will make ClickHouse listen on all IPv4 available on that server.<\/p>\n\n\n\n<p>Do not forget to restart ClickHouse server after making changes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5-2-enable-gui\">5.2 \u2013 Enable GUI<\/h3>\n\n\n\n<p>If you want to access the ClickHouse server using a web browser, you can enable Tabix by editing the same config.xml.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ sudo nano \/etc\/clickhouse-server\/config.xml<\/pre>\n\n\n\n<p>Find the string http_server_default_response, then uncomment the tag line.<\/p>\n\n\n\n<p>Again, restart ClickHouse server for changes to take effect.<\/p>\n\n\n\n<pre id=\"h-systemctl-restart-clickhouse-server\" class=\"wp-block-preformatted\">$ sudo systemctl restart clickhouse-server<\/pre>\n\n\n\n<p>That&#8217;s it. You should be able to access ClickHouse at <code>http:\/\/YOUR_SERVER_IP_ADDRESS:8123\/<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/02\/clickhouse-tabix-login-1024x577.png?v=1644622163\" alt=\"\" class=\"wp-image-40399\"\/><\/figure>\n\n\n\n<p>If during the installation you were not asked to create a clickhouse password, then you can use the following credential to access ClickHouse server:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Username: default&lt;br&gt;Password: [BLANK]<\/pre>\n\n\n\n<p>Yes, let the password field blank and you should be able to log in to the backend.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/02\/clickhouse-tabix-dashboard-1024x579.png?v=1644622182\" alt=\"\" class=\"wp-image-40400\"\/><\/figure>\n\n\n\n<p>Congratulations! You have successfully installed ClickHouse on your Ubuntu VPS. For more information about ClickHouse, please refer to the <a href=\"https:\/\/clickhouse.com\/\" title=\"\">ClickHouse website<\/a>.<\/p>\n\n\n\n<p>PS. If you liked this post on how to install ClickHouse On Ubuntu 20.04, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in real-time and is 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 that can manage large volumes &#8230; <a title=\"How to Install Clickhouse on Ubuntu 20.04\" class=\"read-more\" href=\"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/\" aria-label=\"More on How to Install Clickhouse on Ubuntu 20.04\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[208],"tags":[244,26,210],"class_list":["post-1703","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu","tag-clickhouse","tag-install","tag-ubuntu-20-04"],"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 20.04 | LinuxCloudVPS Blog<\/title>\n<meta name=\"description\" content=\"ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in\" \/>\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-20-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 20.04 | LinuxCloudVPS Blog\" \/>\n<meta property=\"og:description\" content=\"ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-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=\"2022-03-15T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-29T16:17:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2022\/02\/how-to-install-clickhouse-on-ubuntu-20.04.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=\"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-20-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#\\\/schema\\\/person\\\/ed907227ee7d151c617e6d0fe74f531a\"},\"headline\":\"How to Install Clickhouse on Ubuntu 20.04\",\"datePublished\":\"2022-03-15T17:30:00+00:00\",\"dateModified\":\"2023-08-29T16:17:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/\"},\"wordCount\":680,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/how-to-install-clickhouse-on-ubuntu-20.04.jpg\",\"keywords\":[\"clickhouse\",\"install\",\"ubuntu 20.04\"],\"articleSection\":[\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/\",\"name\":\"How to Install Clickhouse on Ubuntu 20.04 | LinuxCloudVPS Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/how-to-install-clickhouse-on-ubuntu-20.04.jpg\",\"datePublished\":\"2022-03-15T17:30:00+00:00\",\"dateModified\":\"2023-08-29T16:17:04+00:00\",\"description\":\"ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/how-to-install-clickhouse-on-ubuntu-20.04.jpg\",\"contentUrl\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/how-to-install-clickhouse-on-ubuntu-20.04.jpg\",\"width\":742,\"height\":372,\"caption\":\"how to install clickhouse on ubuntu 20.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.linuxcloudvps.com\\\/blog\\\/how-to-install-clickhouse-on-ubuntu-20-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 20.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 20.04 | LinuxCloudVPS Blog","description":"ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in","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-20-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install Clickhouse on Ubuntu 20.04 | LinuxCloudVPS Blog","og_description":"ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in","og_url":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/","og_site_name":"LinuxCloudVPS Blog","article_publisher":"http:\/\/www.facebook.com\/LinuxCloudVPS","article_published_time":"2022-03-15T17:30:00+00:00","article_modified_time":"2023-08-29T16:17:04+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2022\/02\/how-to-install-clickhouse-on-ubuntu-20.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-20-04\/#article","isPartOf":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/"},"author":{"name":"admin","@id":"https:\/\/www.linuxcloudvps.com\/blog\/#\/schema\/person\/ed907227ee7d151c617e6d0fe74f531a"},"headline":"How to Install Clickhouse on Ubuntu 20.04","datePublished":"2022-03-15T17:30:00+00:00","dateModified":"2023-08-29T16:17:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/"},"wordCount":680,"commentCount":0,"publisher":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2022\/02\/how-to-install-clickhouse-on-ubuntu-20.04.jpg","keywords":["clickhouse","install","ubuntu 20.04"],"articleSection":["Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/","url":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/","name":"How to Install Clickhouse on Ubuntu 20.04 | LinuxCloudVPS Blog","isPartOf":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2022\/02\/how-to-install-clickhouse-on-ubuntu-20.04.jpg","datePublished":"2022-03-15T17:30:00+00:00","dateModified":"2023-08-29T16:17:04+00:00","description":"ClickHouse is a fast and open-source column-oriented database management system developed by Yandex. It allows generating analytical data reports in","breadcrumb":{"@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-04\/#primaryimage","url":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2022\/02\/how-to-install-clickhouse-on-ubuntu-20.04.jpg","contentUrl":"https:\/\/www.linuxcloudvps.com\/blog\/wp-content\/uploads\/2022\/02\/how-to-install-clickhouse-on-ubuntu-20.04.jpg","width":742,"height":372,"caption":"how to install clickhouse on ubuntu 20.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxcloudvps.com\/blog\/how-to-install-clickhouse-on-ubuntu-20-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 20.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\/1703","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=1703"}],"version-history":[{"count":3,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1703\/revisions"}],"predecessor-version":[{"id":1971,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/posts\/1703\/revisions\/1971"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/media\/1704"}],"wp:attachment":[{"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/media?parent=1703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/categories?post=1703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxcloudvps.com\/blog\/wp-json\/wp\/v2\/tags?post=1703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}