Skip to main content

User Defined Analytic with Functions Range Framing Windows?

  • September 26, 2013
  • 3 replies
  • 20 views

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?

3 replies

Daniel_Leybovic
Forum|alt.badge.img+1
  • Participating Frequently
  • September 26, 2013
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
  • Author
  • New Participant
  • September 26, 2013
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
Forum|alt.badge.img+1
  • Participating Frequently
  • September 26, 2013
>> 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.