In this article we will talk about the Merge operation in HP Vertica. What is Merge and why is important to know how to use it while working with Vertica ? to start with we all know that Vertica is optimized for query-intensive workloads and not for single...

Continue reading

The superuser is created by default when the Vertica instance is created. This use can bypass all types of authorization inside the database. A superuser can grant privileges on all database object types to other users.   The superuser can act on behalf of the object owner and grant or...

Continue reading

Sometimes you want to start from zero in your HP Vertica cluster, so you need to uninstall/remove all old Vertica rpm's and config files. To uninstall HP Vertica follow the steps below: Search for installed Vertica components: [crayon-59e5e62731977625058958/] Stop all Vertica processes running on the host: [crayon-59e5e6273197f550107400/] this command will forcefully...

Continue reading