Archive | vsql RSS feed for this section

Adding a Column Check Constraint

Vertica does not support check constraints for table columns. There are some pretty darn good reasons for that! Probably the best reason is the fact that we want to load data into Vertica super fast. To do that Vertica ignores all constraints assuming we’ve already scrubbed the data we’re loading. So why introduce another hurdle? […]

Read more

AUTOCOMMIT Variable Overrides COPY Command NO COMMIT Option!

According to the documentation, the NO COMMIT option of the COPY command “Prevents the COPY statement from committing its transaction automatically when it finishes copying data.” However, that’s not the case if the AUTOCOMMIT variable is set to ‘on’… Example: I have a table named JULES that I will load 3 records into using the […]

Read more