Hello Keren, An object acquires an O lock (Owner lock) in some DDL operations, such as DROP_PARTITIONS, TRUNCATE TABLE, and ADD COLUMN. When an object is locked in O mode, it cannot be locked simulta… (View Post)

Another example on v11.0.2 CREATE TABLE orders( orderid INT, shipments ARRAY[VARCHAR(100)]);SET ESCAPE_STRING_WARNING TO OFF;SET STANDARD_CONFORMING_STRINGS TO OFF;COPY orders FROM STDIN DELIMITER &#… (View Post)

In addition, the following info can be useful in case one kills the Vertica process without evidence in the vertica.log or Drop the database, or recreate it with the same name, logrotate or replace v… (View Post)

Because of the relation between the infrastructure CPU, I/O workload and File System behaver I would recommend to measure the performance on the target server and storage system to make sure you choo… (View Post)

1) Is Voltage SecureData the only tool in Vertica used for encryption? A - It is not the only option but the best one because of the following benefits: + The ability to protect data as close to its … (View Post)