We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


what is sdk SizedColumnTypes::addIntPartitionColumn method for — Vertica Forum

what is sdk SizedColumnTypes::addIntPartitionColumn method for

Hello

I'm looking for a way to tell vertica that columns coming from my udtf are sorted and partitioned in a specific manner so there is no need to resegment and reorder result dataset. I see there are planty of methods like addIntPartitionColumn and addIntOrderColumn in a SizedColumnTypes class. But setting them in a TransformFunctionFactory::getReturnType makes no difference. What are they for? And is there any way to tell vertica output sortedness for udtf result?

I'm kinda stuck with it. Any advice appreciated

Answers

  • Bryan_HBryan_H Vertica Employee Administrator

    Sort and partition types are used for intermediate steps in multi-phase UDTF and this information is not passed back to the Vertica server yet. However, we have several requests for sort and partition of UDX output so I would recommend contacting support or your account representative if you have one to let us know you need this functionality.

  • Thanx. submitted feature request SD02782237

  • task VER-74383

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file