Search found 1825 matches
- Mon Mar 19, 2012 7:28 pm
- Forum: ODBC
- Topic: ODBC in Windows
- Replies: 7
- Views: 44678
Re: ODBC in Windows
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...
- Mon Mar 19, 2012 2:18 pm
- Forum: New to Vertica
- Topic: Add column to table
- Replies: 8
- Views: 24224
Re: Add column to table
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...
- Fri Mar 16, 2012 4:08 pm
- Forum: Announcements, Events and Activities
- Topic: Hadoop vs PIG vs Vertica for Counting Triangles
- Replies: 4
- Views: 10936
Hadoop vs PIG vs Vertica for Counting Triangles
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
http://nosql.mypopescu.com/post/1072614 ... -triangles
- Thu Mar 15, 2012 12:48 pm
- Forum: Vertica SQL
- Topic: syntax error when creating function
- Replies: 3
- Views: 8891
Re: syntax error when creating function
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...
- Wed Mar 14, 2012 10:08 pm
- Forum: Vertica SQL
- Topic: syntax error when creating function
- Replies: 3
- Views: 8891
Re: syntax error when creating function
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 ...
- Wed Mar 14, 2012 4:00 pm
- Forum: Python
- Topic: Connecting to Vertica
- Replies: 2
- Views: 22855
Re: Connecting to Vertica
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...
- Tue Mar 13, 2012 9:11 pm
- Forum: Vertica Tips, Lessons and Examples
- Topic: Measuring and Setting your Disk Performance
- Replies: 0
- Views: 5167
Measuring and Setting your Disk Performance
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...