Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

INTERPOLATE doesn't work for MergeTree #36530

Closed
yakov-olkhovskiy opened this issue Apr 22, 2022 · 0 comments · Fixed by #36549
Closed

INTERPOLATE doesn't work for MergeTree #36530

yakov-olkhovskiy opened this issue Apr 22, 2022 · 0 comments · Fixed by #36549
Assignees
Labels
potential bug To be reviewed by developers and confirmed/rejected.

Comments

@yakov-olkhovskiy
Copy link
Member

Describe what's wrong
INTERPOLATE doesn't work for tables with ENGINE = MergeTree

Does it reproduce on recent release?
yes

How to reproduce

CREATE TABLE t1 (n Int32) ENGINE = MergeTree ORDER BY n;
INSERT INTO t1 VALUES (1),(3),(3),(6),(6),(6);

SELECT
    n,
    count() AS m
FROM t1
GROUP BY n
ORDER BY n ASC WITH FILL
INTERPOLATE ( m AS m + 1 );

Received exception from server (version 22.5.1):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'm' while processing query: 'SELECT n, count() FROM t1 GROUP BY n ORDER BY n ASC WITH FILL INTERPOLATE ( m AS m + 1 )', required columns: 'n' 'm', maybe you meant: ['n','n']. (UNKNOWN_IDENTIFIER)

Expected behavior
same as

CREATE TABLE t1 (n Int32) ENGINE = Memory;
INSERT INTO t1 VALUES (1),(3),(3),(6),(6),(6);

SELECT
    n,
    count() AS m
FROM t1
GROUP BY n
ORDER BY n ASC WITH FILL
INTERPOLATE ( m AS m + 1 );

┌─n─┬─m─┐
│ 1 │ 1 │
│ 2 │ 2 │
│ 3 │ 2 │
│ 4 │ 3 │
│ 5 │ 4 │
│ 6 │ 3 │
└───┴───┘

Error message and/or stacktrace

Received exception from server (version 22.5.1):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'm' while processing query: 'SELECT n, count() FROM t1 GROUP BY n ORDER BY n ASC WITH FILL INTERPOLATE ( m AS m + 1 )', required columns: 'n' 'm', maybe you meant: ['n','n']. (UNKNOWN_IDENTIFIER)

Additional context
INTERPOLATE is a new feature added in #35349

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
potential bug To be reviewed by developers and confirmed/rejected.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant