largestTriangleThreeBuckets materialized view breaks in Docker #63272
-
There appears to be a weird bug with the usage of largestTriangleThreeBuckets in a materialized view, and Docker. Here is a minimal setup to reproduce the error. It is done inside of the clickhouse container ´clickhouse-test´ CREATE TABLE raw
(
`x` UInt64,
`y` UInt64
)
ENGINE = MergeTree
ORDER BY x;
CREATE TABLE IF NOT EXISTS test
(
`lttb` AggregateFunction(largestTriangleThreeBuckets(10), UInt64, UInt64),
`id` UInt64
)
ENGINE = AggregatingMergeTree
ORDER BY id;
CREATE MATERIALIZED VIEW IF NOT EXISTS test_mv TO test
AS SELECT
x AS id,
largestTriangleThreeBucketsState(10)(x, y) AS lttb
FROM raw
GROUP BY id; This correctly creates the tables and materialized views.
|
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
Nothing to discuss. At an issue. https://fiddle.clickhouse.com/4c3b9b6b-b8ad-46b9-b608-a16bd845a831 |
Beta Was this translation helpful? Give feedback.
-
Also MatView with largestTriangleThreeBuckets has no sense. https://fiddle.clickhouse.com/d6fa9690-7c31-4df0-921d-79dbc3e20484 select to original/source data: 10 rows in set. Elapsed: 0.029 sec
select to materialized view: 10 rows in set. Elapsed: 0.111 sec. |
Beta Was this translation helpful? Give feedback.
Nothing to discuss. At an issue. https://fiddle.clickhouse.com/4c3b9b6b-b8ad-46b9-b608-a16bd845a831