-
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 More -
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 …
Read More -
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 …
Read More -
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 …
Read More -
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 …
Read More -
Exploring Vertica's INTERPOLATE predicate
Jun 18, 2013 | 1 min read hp vertica interpolate previous value SQL analytical sql dbms back fill interpolate vertica fill previous valueVertica has a special feature to join tables and fill in the last available values where values would otherwise be null. I had a similar use case and wanted to test how I could make the best use of it. I played with simple examples and got it right, but with a slightly more complex one, I was stuck or maybe I just …
Read More -
Vertica - 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 -
Viewing function definitions in Vertica
I don't know if you have tried this. But I did try to read function definition from the system tables in Vertica. I used the table called USER_FUNCTIONS which is a table in the V_CATALOG system schema. More details can be found here: https://my.vertica.com/docs/6.1.x/HTML/index.htm#15021.htm But unfortunately when I …
Read More -
Download your free copy of DBVisualizer from http://www.dbvis.com/download/ I am going to give you the steps to setup vertica connection to DB Visualizer on a windows 7. Our windows might look different. But I suppose the terms used on the GUI would match that on any operating system. I know this might be a big …
Read More -
My colleague had an issue in Vertica. He had a set of values in table 1 to be deleted based on the records in a table table2. I didn't think this would be easy considering VERTICA didn't support joins when doing deletes unlike MYSQL. But they do have something else. Let me take you through the steps I followed. I …
Read More