clickhouse-java
clickhouse-java copied to clipboard
need support aggregate function: groupUniqArrayArray
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