mosheg
Administrator
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
mosheg Administrator
Reactions
-
Re: How to read first element from an arraylist which is stored as varchar
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)1 -
Re: Monitoring database start, stop, create, drop database
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)1 -
Re: Which one to choose ext4 vs XFS for disk format
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 -
Re: Vertica Encryption - Hardware / Data
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)1 -
Re: Best practice for Data Aging/ Deleting old data
The best practice is to schedule via cron the use of DROP_PARTITIONS function to drop old partitions as you do. There might be a gap between the time you drop partitions for this to be reflected in D… (View Post)1