Skip to main content

Can we do validations during data load and reject the data if validation fails using COPY?

  • December 19, 2013
  • 1 reply
  • 6 views

Siddarth
Forum|alt.badge.img+1
Can we do it using UDL. If yes than can someone share me an example.

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • December 19, 2013
You can! There are a few examples shipped with Vertica. A simple example can be found by searching for the word "reject" in /opt/vertica/sdkexamples/ParserFunctions/ExampleDelimitedParser.cpp