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 for MV in Proton local mode #808

Open
payamrastogi opened this issue Jul 29, 2024 · 1 comment
Open

Support for MV in Proton local mode #808

payamrastogi opened this issue Jul 29, 2024 · 1 comment
Assignees
Labels
enhancement New feature or request

Comments

@payamrastogi
Copy link

Support for MV in Proton local mode

version: proton local 1.5.14
Device: Mac M1 silicon

currently, while running the following query in the proton local mode results in an exception - Received exception: Code: 2004. DB::Exception: Failed to create inner stream for Materialized view '_local.mv'. (RESOURCE_NOT_INITED)

CREATE MATERIALIZED VIEW mv AS SELECT * FROM github_events

github-example

@payamrastogi payamrastogi added the enhancement New feature or request label Jul 29, 2024
@yokofly yokofly self-assigned this Jul 30, 2024
@yokofly
Copy link
Collaborator

yokofly commented Jul 30, 2024

hi, this is some by design, the proton-local is serverless.
and the mv && simple stream which is storage backend, and what this can do?

  1. create external stream https://docs.timeplus.com/tutorial-github
  2. create random stream(pure in memory) https://docs.timeplus.com/sql-create-random-stream
  3. do some local analysis, probably we can do this CSV/log analysis. i did not found some useful examples

I will refine this error msg. yes, this isn't very clear.
to better explore streaming, I still recommend trying proton-server and proton-client.
and all the above functions also work in the proton-server. this is a superset of proton-local.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants