This move has me worried also. We are thinking of increasing our licence size, but now I am not sure if we should if Vertica will be discontinued. But, I really do not think that is possible?

Hi guys,

So I have a bunch of directories in my data directory that have the prefix CpD...

Example:

drwxrwx--- 3 dbadmin verticadba 4096 May 1 21:24 CpD_1461

Anyone know what these directories are for?

The queries running against views are taking time to execute when CDC is enabled...

Cool topic. I'm sorry to interrupt the flow of this thread, but can someone explain what CDC is?

Hi, I have a three node cluster. After adding/removing nodes I ended up with the following node names: dbadmin=> select node_name from nodes; node_name ----------------------- v_instruments_node0001 v_instruments_node0002 v_instruments_node0004 (1 row) I realize that it is not necessary, but to sati...

Ha hah! Me too!

Debfawn, what version of Vertica are you running??? I thought I had the latest (7.1.2-7)

Norbert, thanks for the reply! I looked at your example and realized I had the BZIP keyword in the wrong location of the copy command. It has to be right after the file name; I had it at the end after the DIRECT keyword. After I moved it, I was able to load the data. Duh!