search

timeplus-io / proton

A streaming SQL engine, a fast and lightweight alternative to ksqlDB and Apache Flink, 🚀 powered by ClickHouse.
https://timeplus.com
Apache License 2.0
1.53k stars 65 forks source link

Support for MV in Proton local mode #808

Open payamrastogi opened 2 months ago

payamrastogi commented 2 months ago

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

yokofly commented 2 months ago

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.