In Vertica the Tuple Mover process is responsible for purging old data. The data that is eligible for purging will listen to the value that the HistoryRetentionTime parameter is set. The default value of this parameter is set to -1, this values tells Vertica that no deleted...

Continue reading
agent_oms

In Vertica we are able to manage and alter the parameters the database listen to. How to see the values of a parameter. Use the query bellow passing the name of the parameter. [crayon-5952929b67746238186277/]  Or by using the SHOW CURRENT statement [crayon-5952929b6774f444942167/]   How to alter the value of a parameter Base Syntax: [crayon-5952929b67754569777378/]   Example...

Continue reading

Recently i have setup a Vertica Cluster and faced some ssh connection laziness, for no reason my ssh connection took like 5 to 10 seconds to complete. After some "debugging" online i have found a cool solution for the problem. It is actually a parameter...

Continue reading

The dbadmin user must have full privileges on the directory in order to create the location. Syntax: [crayon-5952929b68c39715967786/] First create the directory on the host and give ownership to the dbadmin and his group. [crayon-5952929b68c42567892150/]  Create  the storage location inside the database [crayon-5952929b68c47724441233/]   Check the locations [crayon-5952929b68c4b295878814/] Measure the location performance Important to know that...

Continue reading

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-5952929b6b8ab901205499/] Stop all Vertica processes running on the host: [crayon-5952929b6b8b5004618700/] this command will forcefully...

Continue reading