User Defined Analytic with Functions Range Framing Windows?

Kris_Kolve

Can UDAnFs have Framing Window using RANGE? and if so does that mean the analytic partition writer has a different number of rows than the analytic partition reader?

Daniel_Leybovic

Hi! I think here you can get answer: Types of UDFs https://my.vertica.com/docs/6.1.x/HTML/index.htm#15714.htm

Kris_Kolve

I have been all over the documentation. and it is not clear about weather or not you can supply a Range window frame to a User defined analytic function... it does say however that you can not supply a ROW window frame

Daniel_Leybovic

>> does that mean the analytic partition writer has a different number of rows than the analytic partition reader? May be Im one more time not in place:

Note: You must be sure that your function produces a row of output for each row of input in the partition. You must also not output more rows than are in the partition, otherwise the zygote size process (if running in fenced mode) or Vertica itself could generate an out of bounds error.