Eric Fu
Eric Fu
related https://github.com/risingwavelabs/risingwave/issues/14821
> So currently when a streaming job is dropped, it's metrics will be leaked (i.e., prometheus collected some useless data, which is always zero valued), right? True. Part of them...
> thinking it can be integrated into the `diagnose` command, users just one click and print all the query plans for off-site debugging Right. That's also what I think.
Can this just be expressed with ```sql create materialized view xxx as generate_series( '2020-01-01 00:00:00'::TIMESTAMP, -- start NOW(), -- end interval '1' minute -- step ); ``` Internally, `NowExecutor` will...
> also it is a big generate_series batch query. Didn't get this. Can you explain it? I don't see any batch query here. By the way, regarding the original query...
> Oh, create mv with a `generate_series` is even worse > > ``` > create materialized view xxx as generate_series( > '2020-01-01 00:00:00'::TIMESTAMP, -- start > NOW(), -- end >...
By the way, share the [`time_bucket_gapfill`](https://docs.timescale.com/api/latest/hyperfunctions/gapfilling/time_bucket_gapfill/#time_bucket_gapfill-functions) from TimescaleDB. Compared with `Join`, it has 2 advantages: 1. It allows specifying how to interpolate values. 2. Streaming `Join` is very expensive Regarding...
> > Streaming Join is very expensive > > So, Even a streaming `time_bucket_gapfill` is better because it exploits the property that the time columns are basically ordered and that...
#16234 was closed by #16337. > We can keep the old code for existing users, but the default behavior should be using v2 i.e. No _v2 prefix in s3_v2 So,...
> https://docs.dolphindb.cn/en/help/SQLStatements/interval.html Interesting. While for RisingWave, the closest syntax is actually the time window function i.e. `TUMBLE` and `HOP`. But regarding of implementation, it seems that reusing the state in...