Thanks, Jim! That fixed my problem!!!

Hi all, I need some help with a Vertica install on CentOS. Below is the install command I ran, followed by the error I receive. Anyone know what the heck that error means? [root@vertica01 vertica_temp]# /opt/vertica/sbin/install_vertica -s 209.166.166.180,209.166.166.179,209.166.166.181 -r vertica-6...

Thank you, Jim! I will start using su with the hyphen.

Hello,

When switching to the root user, what is the difference between using the "su root" command and the "su - root" command? Either way seems to work fine for me. I was just curious which method is best practice.

Thank you.

Hi,

Does anyone know the difference between the node state "UP" and "READY" from the NODE_STATE column in the NODE_STATES system table?

Thanks

Thanks, Tom! Great example!

Hello,

My boss asked me to generate a daily report (sent via email) which shows the total number of rows for all tables in our DB. Is there an easy way to calculate this sum?

Thanks all!