ClickHouse

Use JdbcTemplate, Mapper, or the Builder API to query and insert ClickHouse data. For changes to MergeTree tables, see the mutation example below.

Scenario	Usage
Key generation	Application-generated IDs
Pagination	LIMIT pagination
Insert conflicts	Duplicate records in MergeTree
Data changes	Submit, wait for, and inspect mutations

• Programmatic API: queries, writes, multiple results, and stored routine differences.
• Mapper API: annotations, Mapper reads and writes, and execution differences.
• Builder API: Supported operations, datasource-specific behavior, and usage.
• Waiting for Data Changes: Wait for changes and inspect failures.
• Batch Inserts: Submit multiple events together.
• Pagination: Page queries and total counts.
• Duplicate Records: Read the latest version of a repeated ID.
• Vector Operations: Field mapping, search metrics, and supported queries.
• Key Generation: Configure and retrieve IDs.
• Type Support: Choose Java property types.
• Transaction Support — transaction API behavior and isolation settings.