If you already have a Vertica Database on prem; and if you want the same node count - and the same Vertica version - in the Cloud, all you do is backup the on-prem database; In the case of Azure, GCP… (View Post)

This is how IMPLODE() works: WITH car_sales(manufact,"type") AS ( SELECT 'Morgan','Plus 6' UNION ALL SELECT 'Morgan','Plus 4' UNION ALL SELECT '… (View Post)

As @mosheg said - any column_name VARCHAR(n) or code_name CHAR(2) is always for a variable length or fixed length string encoded in UTF-8. This means that a string containing the Euro sign four times… (View Post)

Looking at it again, your hierarchical partitioning clause that you are using is not hierarchical. Matched with my table, it would be: ALTER TABLE hierpart PARTITION BY ((dt)::DATE) GROUP BY (DATE_TR… (View Post)

It looks like you are trying to drop partitions in a table with hierarchical partitioning - where at least a range of the partition keys you intend to drop are in grouped partitions. What is happenin… (View Post)