Dear Joerg - I can see that you have COPY with SOURCE KAFKASOURCE(), meaning that you have activated at least a Kafka source, if not a Vertica Kafka micro batch scheduler. Best practice, indeed, is t… (View Post)

A TRUNCATE is a DDL operation, and it requires both an exclusive lock on the truncated table and on the global catalogue. And if it cannot acquire that lock, it waits for 5 minutes, by default. The d… (View Post)

This is more detailed - if you want, for example, to find the 4 biggest partitions in the database: SELECT t.table_schema, t.table_name, p.partition_key, SUM(p.ros_size_bytes) AS ros_size_bytesFROM T… (View Post)

I think you can achieve it using a NVL() function. If a flattened column is NULL because the matching - found - column of the joined row in the dimension table is NULL, then your expression works. If… (View Post)

Subtracting two timestamps from each other returns an INTERVAL DAY TO SECOND. Up to 23 hours, 59 minutes and 59 seconds, that data type formats like a TIME type. Above 24 hours, it has the days, form… (View Post)