Dates incorrectly serialized to pulsar as integers from groupby columns in materialized views

Groupby date columns are serialized to pulsar as integers and no longer as date strings.

For example if date being grouped by is '2024-04-25'

Then on pulsar it is emitted as number 739002 but in a sql select query the value is correct as '2024-04-25;

This only seems to happen when sinking MVs that have been grouped by. Non group by MVs emit the date to pulsar correctly as a string.

No response

sometable has column dt as type date

create materialized view abc_mv as
select dt, sum(val)
from sometable
group by dt

create sink abc_sink
from abc_mv
with ... pulsar
format upsert encode json

I expected the output value of dt in the pulsar message json to be '2024-04-25' but it was 739002

Running from command line standalone

PostgreSQL 13.14.0-RisingWave-1.8.0 (unknown)

No response

risingwavelabs / risingwave