Skip to main content
Question

what is sdk SizedColumnTypes::addIntPartitionColumn method for

  • Oct 8, 2020 6:03 PM UTC
  • 3 replies
  • 19 views

phil2
Forum|alt.badge.img+2
  • Participating Frequently

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

3 replies

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • Oct 13, 2020 3:46 PM UTC

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.


phil2
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Oct 16, 2020 3:52 PM UTC

Thanx. submitted feature request SD02782237


phil2
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Oct 20, 2020 2:50 PM UTC

task VER-74383