The Vertica Forum recently got a makeover! Let us know what you think by filling out this short survey.

User Defined Analytic with Functions Range Framing Windows?

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

  • 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
  • >> 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.