Typical Application Scenarios

You can quickly learn and master the development process of ClickHouse cold and hot data separation and know the functions of key APIs in a typical use case.

Description

Suppose a user creates a web system and uses the table test_tbl to log website visits in real-time. The following table lists an example of the recorded data.

**Table 1** Raw data
timestamp	type	error_code	error_msg	op_id	op_time
2024-06-04 10:36:00	1	404	Resource Not Found	998756	2024-06-04 11:36:00
2024-06-04 10:35:00	1	404	Resource Not Found	998756	2024-06-04 11:35:00
2024-06-03 10:33:00	1	404	Resource Not Found	998756	2024-06-03 11:33:00
2024-03-27 09:10:00	1	200	ok	998756	2024-03-27 10:10:00
2024-03-25 11:08:00	1	404	Resource Not Found	998756	2024-03-25 12:08:00

Data Planning

Data is written on the hour of the current day. The data of the previous day is seldom accessed and is automatically archived to the cold storage to save storage space.

Parent topic: Developing ClickHouse Cold-Hot Separation Applications

Previous topic: Application Background

Next topic: Development Guidelines