Vertica and K-Safety

So 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 amazing. I don’t know if you have heard of the term K-Safe or K-Safety. When I first heard it, I had no idea what it was....

November 6, 2013 · 2 min · 382 words

SQuirreL graphical user interface for Vertica

Hey guys, I tried out DBVisualizer earlier. I liked it and I have blogged about setting that up for your Vertica database. But it is expensive. I mean I can’t buy it for my personal use unless a company actually sponsors me. I’m a poor developer you see. So I searched for alternatives and I kind of liked SQuirrel SQL client. It is a java based open source SQL client which is pretty awesome....

September 24, 2013 · 5 min · 1030 words

Vertica 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 various ways depending on the K Safety and the Segmentation options that we choose when creating the table....

September 12, 2013 · 5 min · 915 words

Vertica, Admin rights and Developer roles

For the past few weeks I have been really depressed and pissed at work. I love what I am currently working on but unfortunately I just don’t have enough freedom to do what I want. How would you feel if you had to rely on silly things on a person who belonged to a completely different team? I work on Vertica. And Vertica has something called a Database designer, which for some reason can only be run by someone who has admin rights....

July 7, 2013 · 2 min · 313 words

Vertica and its version - Find out using SQL

I was playing around with Vertica and my friend suddenly asked me what version of Vertica I was using. This was because he was trying to debug something and posted a question to guys from Vertica and they asked him that question. At my workplace we use the same Vertica cluster for development. It is a playground with a lot of restrictions. Without DB Admin access you can’t really explore much in Vertica....

June 24, 2013 · 1 min · 167 words