1. [Home](https://www.g2.com/) 2. ... 3. [Real-time Analytic Database Software](https://www.g2.com/categories/real-time-analytic-database) 4. [ClickHouse Discussions](https://www.g2.com/products/clickhouse/discuss) [ ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_96da94cbf326ecdccde378ca6d78d8df/clickhouse.png "Product Avatar Image") ](/products/clickhouse/reviews) [ ClickHouse ](/products/clickhouse/reviews) (23)4.5/5 ClickHouse is the fastest and most resource efficient real-time database and data warehouse. ClickHouse is optimized to serve a wide range of data-intensive workloads, from powering interactive user-facing dashboards to running ad-hoc historical analysis over petabytes of data. Today, ClickHouse Cloud is used by enterprises all over the world, including Lyft, Sony, IBM, GitLab, Twilio, HubSpot, and many more. ClickHouse is available open-source or through cloud services on AWS, GCP, and soon, Azure. Show More * * * ### 54.0 Nps Score Already have ClickHouse? ### All ClickHouse Discussions Search Most CommentedMost HelpfulPinned by G2Newest All DiscussionsDiscussions with CommentsPinned by G2Discussions without Comments FilterFilter Filter byExpand/Collapse Sort by Most Commented Most Helpful Pinned by G2 Newest Filter by All Discussions Discussions with Comments Pinned by G2 Discussions without Comments ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • over 3 years ago More Options - [ # Why is ClickHouse faster? ](/discussions/why-is-clickhouse-faster) Why is ClickHouse faster? [ Database Management Systems (DBMS) ](https://www.g2.com/tags/database-management-systems-dbms)[ Relational Databases ](https://www.g2.com/tags/relational-databases)[ Columnar Databases ](https://www.g2.com/tags/columnar-databases) * * * \<0\>0\>Upvotes * * * 0 Comments [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.&title=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • over 3 years ago More Options - [ # Is ClickHouse SQL database? ](/discussions/is-clickhouse-sql-database) Is ClickHouse SQL database? [ Database Management Systems (DBMS) ](https://www.g2.com/tags/database-management-systems-dbms)[ Relational Databases ](https://www.g2.com/tags/relational-databases)[ Columnar Databases ](https://www.g2.com/tags/columnar-databases) * * * \<0\>0\>Upvotes * * * 0 Comments [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.&title=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • almost 4 years ago More Options - [ # Is ClickHouse a datawarehouse? ](/discussions/is-clickhouse-a-datawarehouse) Is ClickHouse a datawarehouse? [ Database Management Systems (DBMS) ](https://www.g2.com/tags/database-management-systems-dbms)[ Relational Databases ](https://www.g2.com/tags/relational-databases)[ Columnar Databases ](https://www.g2.com/tags/columnar-databases) * * * \<0\>0\>Upvotes * * * 0 Comments [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.&title=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • about 4 years ago More Options - [ # What is ClickHouse good for? ](/discussions/what-is-clickhouse-good-for) What is ClickHouse good for? [ Database Management Systems (DBMS) ](https://www.g2.com/tags/database-management-systems-dbms)[ Relational Databases ](https://www.g2.com/tags/relational-databases)[ Columnar Databases ](https://www.g2.com/tags/columnar-databases) * * * \<0\>0\>Upvotes * * * 0 Comments [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.&title=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=ClickHouse+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=ClickHouse+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%0aAsk+ClickHouse+questions+and+get+answers+from+expert+users+in+our+ClickHouse+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ## Start a New Software Discussion Have a software question? Get answers from real users and experts [Start A Discussion](/products/clickhouse/discussions/new) * * * ![Product Avatar Image](https://images.g2crowd.com/uploads/product/hd_favicon/1085fc1aec988cc21861ba894db51044/clickhouse.svg "Product Avatar Image") ### Have you used ClickHouse before? Answer a few questions to help the ClickHouse community [ Yes ](javascript:void(0))[ Yes ](https://www.g2.com/authorize?form=signup&return_to=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fclickhouse%2Fdiscuss%3Fsmall_ask%3Dclickhouse) No