mosheg
Administrator
mosheg Administrator
Reactions
-
Re: one vertica Node is down in cluster
Please open a support case to investigate why the same node goes down. In general, you can see messages in the file vertica.log To find where vertica.log file is located run the command: admintools -… (View Post)1 -
Re: What is this error? (about kafkaExport function)
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)1 -
Re: How to get column sizes for single daily partition
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)1 -
Re: When we run query to check last accessed on a table how long does it look back in time?
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)1 -
Re: New feature request - swap_tables
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)2