Skip to main content

Tell us your data loading preferences

  • July 31, 2018
  • 2 replies
  • 6 views

Forum|alt.badge.img+2

We’re back with our newest product management survey for this summer! This time we’re asking about how you load your data – everything from the ETL tools you use to how you manage your information. The answers you provide will help us fit Vertica into your infrastructure in a way that is ideal for your needs. Click below to take the survey and thank you for your investment in improving Vertica!

https://in.hotjar.com/s?siteId=438341&surveyId=91386

2 replies

ScottL
Forum|alt.badge.img+1
  • Participating Frequently
  • July 31, 2018

Speaking of data loading! :) We have a question about the ApportionedLoad process.

We were unclear as to whether 1 UDF could cover all the different loads or would there be 1 UDF for each load? From reading the 9.1 doco, it looks like the UDParser step would require a specific parser for each table so multiple UDFs would have to be written.

You use three types of UDL functions during development, one for each stage of the data-load process:
[omitted the first two]
• User-Defined Parser (UDParser): Up to one parser parses the data into tuples that are ready to be inserted into a table. For example, a parser could extract data from an XML-like format. You can optionally define a User-Defined Chunker (UDChunker, C++ only), to have the parser perform parallel parsing.

Can someone confirm?
Thanks


ScottL
Forum|alt.badge.img+1
  • Participating Frequently
  • August 1, 2018

I'll move this to it's own post! :)