Options

User Defined Analytic with Functions Range Framing Windows?

Kris_KolveKris_Kolve
in General Discussion
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?

Comments

  • Options
    Daniel_LeybovicDaniel_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
  • Options
    Kris_KolveKris_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
  • Options
    Daniel_LeybovicDaniel_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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...