Skip to content

corrMatrix does not actually support Decimal types despite documentation claiming so #3814

Open
@Astimus

Description

@Astimus

Company or project name

Visiology

Describe the issue

The documentation for the corrMatrix aggregate function states that it accepts parameters of types (U)Int*, Float*, Decimal.

However, when actually using Decimal types, the function throws an error like:

Received exception from server (version 24.8.11):
Code: 43. DB::Exception: Received from localhost:9000. DB::Exception: Aggregate function corrMatrix only supports numerical types. (ILLEGAL_TYPE_OF_ARGUMENT)
(query: SELECT corrMatrix(x, y)
FROM (
    SELECT arrayJoin([
        (toDecimal64(1.0, 2), toDecimal64(2.0, 2)),
        (toDecimal64(2.0, 2), toDecimal64(4.0, 2)),
        (toDecimal64(3.0, 2), toDecimal64(6.0, 2)),
        (toDecimal64(4.0, 2), toDecimal64(8.0, 2)),
        (toDecimal64(5.0, 2), toDecimal64(10.0, 2))
    ]) AS tpl
) AS src
ARRAY JOIN [tpl.1] AS x, [tpl.2] AS y;)

https://fiddle.clickhouse.com/511e3357-514a-483e-a5e8-8da312ad2a19

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions