pipelinedb Continuous Views xxx_mrel NUMERIC to bytea?

Question

enter image description hereI ran into a problem with pipelinedb.

There is a NUMERIC type field in the Continuous Views I built, but the mrel table generated in pipelinedb is bytea. Why is this?

Have you met? There is a good solution. Thank you

Here is the photos：

This is the result of the two columns

This is the difference between the two columns

If you can post actual code, what error you are getting, and what you are expecting, people will be able to help you much better. — levininja, Apr 18 '18 at 03:26
Thank you for your reminding. You can see the next two pictures — LiMeng Ren, Apr 18 '18 at 05:22

score 0 · Answer 1 · answered Apr 23 '18 at 19:49

Materialization tables (<cv name>_mrel>) store all of the state necessary to incrementally update aggregate values. These are called "transition" values. For example, to incrementally update an average, both the item count and sum must be stored; storing the average itself is not sufficient.

Some of these transition values are encoded as bytea. There is then an "overlay" view on top of the materialization table that "finalizes" the transition value at read time to give you the up-to-date aggregate value.

Thank you very much. Now I know why it's a byte. But I still confuse how to get data in bytes. Just cv? — LiMeng Ren, May 04 '18 at 03:15

pipelinedb Continuous Views xxx_mrel NUMERIC to bytea?

1 Answers1