基于Clickhouse的大数据对比分析应用案例

Case Stduy on Comparative Analysis of Big Data Based on Clickhouse

阐述一个新型的OLAP数据库Clickhouse,从多个维度切入、分析了纽约出租车大数据的4个场景,在分析过程中,使用Clickhouse,PostgreSql的行式模式和列式模式进行性能对比。测试结果表明,使用Clickhouse数据库在存储效率,导入性能,分析性能方面均大幅胜出,在OLAP领域应用非常合适。

This paper expounds a new OLAP database Clickhouse, and analyzes four scenarios of New York taxi big data from multiple dimensions. In the analysis process, the row mode and column mode of Clickhouse and Postgre SQL are used for performance comparison. The test results show that the use of Clickhouse database has greatly won in terms of storage efficiency, import performance and analysis performance. It is very suitable for application in the field of OLAP.