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

Support MVs without key column. #5125

Open
big-andy-coates opened this issue Apr 21, 2020 · 0 comments
Open

Support MVs without key column. #5125

big-andy-coates opened this issue Apr 21, 2020 · 0 comments

Comments

@big-andy-coates
Copy link
Contributor

big-andy-coates commented Apr 21, 2020

The rejected alternatives section of KLIP-25 talks about supporting creating MVs without key columns, e.g.

CREATE TABLE OUTPUT AS SELECT COUNT() FROM INPUT GROUP BY X;

The above should create a table, (well, MV really), which internally tracks X as the primary key to allow correct processing of updates, but externally has no X column.

This means X should not appear in the output of SELECT * FROM OUTPUT or DESCRIBE SOURCE OUTPUT, etc.

Nor should X be available in downstream queries.

Both tables and streams MVs should support this.

@big-andy-coates big-andy-coates changed the title Support persistent queries without key column. Support MVs without key column. Apr 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant