Hi guys, Is there a way to systematically check if a view is valid or invalid? In Oracle I've used the STATUS column in the ALL_OBJECTS system table to determine this. I can't find a similar column in Vertica. dbadmin=> create table test (id int, name varchar(10)); CREATE TABLE dbadmin=> create view...

NICE! Thanks for the quick response

Hello,

In vsql is there an option of the \o meta-command that will append output from my sql commands to a file as opposed to replacing the file?

Thank you, sKwa. I've decided to keep all of my partition expression's data types as INT whenever possible.

Hi,

This may seem like a dumb question, but does the data type of a table's partition expression matter for performance? Does an INT perform better than VARCHAR?

What happens if two of the nodes fail? Won't you loose everything, Sarah?

Hi all,

Has anyone heard any of the new features that will be included in Vertica 7?