Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

aggThrow

View as MarkdownEdit this pageReport an issueSet up docs MCP

aggThrow

Introduced in: v20.1.0

This function can be used for the purpose of testing exception safety. It will throw an exception on creation with the specified probability.

Syntax

aggThrow(throw_prob)

Arguments

  • throw_prob — Probability to throw on creation. Float64

Returned value

Returns an exception: Code: 503. DB::Exception: Aggregate function aggThrow has thrown exception successfully.

Examples

Usage example

SELECT number % 2 AS even, aggThrow(number) FROM numbers(10) GROUP BY even;
Received exception:
Code: 503. DB::Exception: Aggregate function aggThrow has thrown exception successfully: While executing AggregatingTransform. (AGGREGATE_FUNCTION_THROW)
Navigation