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

CREATE MATERIALIZED VIEW Failed for streaming query #498

Closed
yl-lisen opened this issue Jan 17, 2024 · 1 comment · Fixed by #499
Closed

CREATE MATERIALIZED VIEW Failed for streaming query #498

yl-lisen opened this issue Jan 17, 2024 · 1 comment · Fixed by #499
Assignees
Labels
bug Something isn't working

Comments

@yl-lisen
Copy link
Collaborator

yl-lisen commented Jan 17, 2024

Describe what's wrong

create stream dim_t(id int, type int);
create stream vk(id int, value float) primary key id settings mode='versioned_kv';
create materialized view mv as with list as (select id from table(dim_t)) select id, value from vk where id in list;

But got exception:
Received exception from server (version 1.3.31):
Code: 48. DB::Exception: Received from localhost:8463. DB::Exception: SUBSCRIBE can only work with streaming query. (NOT_IMPLEMENTED)

How to reproduce

Error message and/or stacktrace

Additional context

@yl-lisen yl-lisen added the bug Something isn't working label Jan 17, 2024
@yl-lisen yl-lisen self-assigned this Jan 17, 2024
@jovezhong
Copy link
Contributor

(Jove Github Bot) added it to the current sprint.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants