Recently one of the customers wanted me to evaluate and recommend a Columnar Database System of Data Analytics. I have chosen ClickHouse, Vertica, Greenplum and MariaDB ColumnStore for this exercise. I have to admit all […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46,47,48,45,49],"tags":[50,51,52,53],"yoast_head":"\nBenchmarking ClickHouse<\/title>\n<meta name=\"description\" content=\"ClickHouse Benchmarking\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Benchmarking ClickHouse\" \/>\n<meta property=\"og:description\" content=\"ClickHouse Benchmarking\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/\" \/>\n<meta property=\"og:site_name\" content=\"The WebScale Database Infrastructure Operations Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/TheWebScaleDBA\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-10T14:22:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-17T19:01:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Shiv Iyer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@http:\/\/twitter.com\/thewebscaledba\" \/>\n<meta name=\"twitter:site\" content=\"@webscaledba\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shiv Iyer\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/\"},\"author\":{\"name\":\"Shiv Iyer\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\"},\"headline\":\"Benchmarking ClickHouse\",\"datePublished\":\"2018-01-10T14:22:05+00:00\",\"dateModified\":\"2019-05-17T19:01:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/\"},\"wordCount\":84,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"keywords\":[\"ClickHouse\",\"ClickHouse Performance\",\"Data Analytics\",\"Massively Parallel Processing Systems\"],\"articleSection\":[\"ClickHouse\",\"ClickHouse Performance Benchmarking\",\"Columnar Database System\",\"Data Analytics\",\"Massively Parallel Processing Systems\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/\",\"url\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/\",\"name\":\"Benchmarking ClickHouse\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/#website\"},\"datePublished\":\"2018-01-10T14:22:05+00:00\",\"dateModified\":\"2019-05-17T19:01:42+00:00\",\"description\":\"ClickHouse Benchmarking\",\"breadcrumb\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/minervadb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Benchmarking ClickHouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/minervadb.com\/#website\",\"url\":\"https:\/\/minervadb.com\/\",\"name\":\"The WebScale Database Infrastructure Operations Experts\",\"description\":\"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations\",\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/minervadb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/minervadb.com\/#organization\",\"name\":\"MinervaDB\",\"url\":\"https:\/\/minervadb.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"width\":200,\"height\":200,\"caption\":\"MinervaDB\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/webscaledba\",\"https:\/\/www.linkedin.com\/company\/minervadb\/\",\"https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\",\"name\":\"Shiv Iyer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"caption\":\"Shiv Iyer\"},\"description\":\"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.\",\"sameAs\":[\"http:\/\/minervadb.com\",\"https:\/\/www.facebook.com\/TheWebScaleDBA\",\"https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba\"],\"url\":\"https:\/\/minervadb.com\/index.php\/author\/shiv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Benchmarking ClickHouse","description":"ClickHouse Benchmarking","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:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/","og_locale":"en_US","og_type":"article","og_title":"Benchmarking ClickHouse","og_description":"ClickHouse Benchmarking","og_url":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/","og_site_name":"The WebScale Database Infrastructure Operations Experts","article_publisher":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_author":"https:\/\/www.facebook.com\/TheWebScaleDBA","article_published_time":"2018-01-10T14:22:05+00:00","article_modified_time":"2019-05-17T19:01:42+00:00","og_image":[{"width":200,"height":200,"url":"https:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg","type":"image\/jpeg"}],"author":"Shiv Iyer","twitter_card":"summary_large_image","twitter_creator":"@http:\/\/twitter.com\/thewebscaledba","twitter_site":"@webscaledba","twitter_misc":{"Written by":"Shiv Iyer"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#article","isPartOf":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/"},"author":{"name":"Shiv Iyer","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618"},"headline":"Benchmarking ClickHouse","datePublished":"2018-01-10T14:22:05+00:00","dateModified":"2019-05-17T19:01:42+00:00","mainEntityOfPage":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/"},"wordCount":84,"commentCount":0,"publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"keywords":["ClickHouse","ClickHouse Performance","Data Analytics","Massively Parallel Processing Systems"],"articleSection":["ClickHouse","ClickHouse Performance Benchmarking","Columnar Database System","Data Analytics","Massively Parallel Processing Systems"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/","url":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/","name":"Benchmarking ClickHouse","isPartOf":{"@id":"https:\/\/minervadb.com\/#website"},"datePublished":"2018-01-10T14:22:05+00:00","dateModified":"2019-05-17T19:01:42+00:00","description":"ClickHouse Benchmarking","breadcrumb":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/10\/benchmarking-clickhouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minervadb.com\/"},{"@type":"ListItem","position":2,"name":"Benchmarking ClickHouse"}]},{"@type":"WebSite","@id":"https:\/\/minervadb.com\/#website","url":"https:\/\/minervadb.com\/","name":"The WebScale Database Infrastructure Operations Experts","description":"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations","publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minervadb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/minervadb.com\/#organization","name":"MinervaDB","url":"https:\/\/minervadb.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","width":200,"height":200,"caption":"MinervaDB"},"image":{"@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/webscaledba","https:\/\/www.linkedin.com\/company\/minervadb\/","https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618","name":"Shiv Iyer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","caption":"Shiv Iyer"},"description":"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.","sameAs":["http:\/\/minervadb.com","https:\/\/www.facebook.com\/TheWebScaleDBA","https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba"],"url":"https:\/\/minervadb.com\/index.php\/author\/shiv\/"}]}},"_links":{"self":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/606"}],"collection":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/comments?post=606"}],"version-history":[{"count":7,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/606\/revisions"}],"predecessor-version":[{"id":2245,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/606\/revisions\/2245"}],"wp:attachment":[{"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/media?parent=606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/categories?post=606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/tags?post=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}