Are you working on a project where you'd like to classify position data into geographic region? The US Census Bureau provides shapefiles for ZIP code tracts that you can ingest into Vertica and … (View Post)

What version of g++ is installed? Be sure it is recent enough to include C++11 support, e.g. $ g++ --version g++ (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39) (View Post)

There is a brief global lock while Vertica prepares a snapshot of the database. Then the snapshot is used to copycluster. (View Post)

It's also possible to set password on the command line with the -w switch, though this is also accessible to any user who can read the script. Is it possible to isolate the scheduler user and ho… (View Post)

Hi, there should be no issue with dropping and re-creating tables. I am aware of several customers that create staging tables and swap partitions as you describe. However, it is strongly recommended … (View Post)