clickhouse-java icon indicating copy to clipboard operation
clickhouse-java copied to clipboard

need support aggregate function: groupUniqArrayArray

Open yandd opened this issue 3 years ago • 0 comments

DDL:

CREATE MATERIALIZED VIEW log.slog_columns
(
    `_namespace` LowCardinality(String),
    `app` LowCardinality(String),
    `_string_columns` SimpleAggregateFunction(groupUniqArrayArray, Array(String)),
    `_number_columns` SimpleAggregateFunction(groupUniqArrayArray, Array(String)),
    `_date` Date
)
ENGINE = ReplicatedAggregatingMergeTree('/clickhouse/tables/{single_shard_cluster}/{single_shard}/log/.inner_id.17f49fce-b895-461c-97f4-9fceb895e61c', '{replica}')
PARTITION BY toYYYYMMDD(_date)
ORDER BY (_namespace, app, _date)
TTL _date + toIntervalDay(15)
SETTINGS index_granularity = 8192 AS
SELECT
    _namespace,
    app,
    groupUniqArrayArray(string.names) AS _string_columns,
    groupUniqArrayArray(number.names) AS _number_columns,
    toDate(_timestamp) AS _date
FROM log.slog
GROUP BY
    _namespace,
    app,
    _date

yandd avatar Aug 29 '22 10:08 yandd