Hi, You can connect to a Vertica database in MS Windows via the Vertica ODBC driver which is bundled with the JDBC driver in the 32-Bit and 64-Bit Windows Client software available for download from Vertica's website. Installation of the software is pretty straight forward, just make sure the bit co...

Hi, Yes, to add a column to a table you have to follow the same basic steps as were discussed in the "How to drop columns from a table" post: http://vertica-forums.com/viewtopic.php?f=7&t=4 When adding a column, you can follow these simple steps: 1) Create a new table having the same basic structure...

Here is a link that discusses the performance of Hadoop vs PIG vs Vertica ([spoiler alert] Vertica wins!!!)

http://nosql.mypopescu.com/post/1072614 ... -triangles

Hi, I confirmed that DbVisualizer thinks there are multiple SQL statements in the code and I get the same error you are receiving. Try running the create statement with the delimiters: --/ create function fun1(x int) return int as begin return 1; end; / This runs okay for me in DbVisualizer. Or, you...

Hi, Hmm. Your code looks okay. What version of Vertica are you using? Are you running the create statement in vsql or some other tool? If it's not in vsql , maybe the tool you are using is interpreting the first semi-colon as the end of your statement. There maybe some sort of delimiter you need to ...

Hi Patrick, In order to connect to Vertica using Python, you have to have the pyodbc module and a Vertica ODBC driver installed on the machine where Python itself is installed. Most Linux distributions have Python installed by default. Although, there is typically a newer version which you can downl...

There are two storage management functions in Vertica that allow us to measure and record the performance characteristics (Throughput and Latency) of our individual storage locations. It's especially important to gather this information if you have multiple storage locations on the same node. Vertic...