The flow example not working

[killme2008]

What type of bug is this?

Incorrect result

What subsystems are affected?

Datanode

Minimal reproduce step

The example in blog https://greptime.com/blogs/2024-06-04-flow-engine#what-is-continuous-aggregation

It doesn't work as expected. FYI, the DDL of calc_avg_speed doesn't exist at all @Wenjie0329

The error info:

2024-11-12T09:37:36.684196Z ERROR flow::adapter: Send writeback request errors err=0: External error, at src/flow/src/adapter.rs:334:30
1: External error, at src/flow/src/server.rs:495:14
2: Failed to insert data, at src/operator/src/insert.rs:335:26
3: External error, at src/frontend/src/instance/standalone.rs:87:14
4: Operation to region server failed, at src/frontend/src/instance/standalone.rs:69:14
5: Execute gRPC request error, at src/datanode/src/region_server.rs:381:18
6: Failed to handle request for region 5476083302400(1275, 0), at src/datanode/src/region_server.rs:770:14
7: Invalid request to region 5476083302400(1275, 0), reason: value has type Float64, but column avg_speed has type Ok(Float32)(9), at src/mito2/src/request.rs:372:9

Looks like the avg((left_wheel+right_wheel)/2) returns f64 and can't be inserted.

What did you expect to see?

NA

What did you see instead?

NA

What operating system did you use?

All

What version of GreptimeDB did you use?

v0.9.5

Relevant log output and stack trace

No response