Vertica and K-Safety
Nov 6, 2013 | 2 min read columnar database hp vertica distributed database system big data vertica high performance database systemSo you probably know that I have been working with HP's Vertica. I'm very glad that I had this opportunity to interact with something like this. The technology behind it is pretty new and immature and lacks the power of PL/SQL but the speed that it achieves through massive parallel execution of queries is simply …
Read MoreVertica Query Performance Tuning - An introduction
Hey there, I guess you have been having a lot fun with your Vertica databases. I thought I'd share some of the things that I did to improve my query performance. Tables and Projections in Vertica In Vertica even though we access data through tables everything is stored in projections which are stored among nodes in …
Read MoreVertica - Calendar table with dates from a start date to an end date using analytical SQL
Jun 18, 2013 | 1 min read columnar database hp vertica SQL calendar dbms dates vertica database systemsI had a problem creating a table with just SQL that is supported by Vertica. Most of the solutions that I came across online were using procedures. But after a lot of playing around and reading vertica documentation I found a solution to my problem. read more about the problem and the solution at Stackoverflow
Read More