Thank you for reaching out, Karthik. After consulting with our Kafka experts, it appears that the reported issue related to a Kafka connectivity. Based on the message provided, it seems that a reques… (View Post)

Check the table PARTITION_COLUMNS as shown here: https://www.vertica.com/docs/12.0.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/PARTITION_COLUMNS.htm E.g. SELECT NODE_NAME, PROJEC… (View Post)

When we run query to check last accessed on a table how long does it look back in time? The amount of time that the query will look back in time will depend on the retention settings for the Data Col… (View Post)

Thank you for your question. It is possible to use one statement like ALTER TABLE...RENAME TO to swap tables within the same schema, without actually moving data as mentioned here: https://www.vertic… (View Post)

UTF-8 is a variable-length character encoding and can represent any universal character in the Unicode standard. Vertica expect to receive all data in UTF-8, and also outputs all data in UTF-8. It is… (View Post)