T-Ek-nolo-G-i-K

Search This Blog

History of Programming Languages an Infographic

April 17, 2013

Get link
Facebook
X
Pinterest
Email
Other Apps

Infographic by Veracode Application Security

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Vertica - Calendar table with dates from a start date to an end date using analytical SQL

I 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

Setup DBVisualizer with an HP Vertica DB connection

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 assumption as I don't work for DBVisualizer and I haven't installed it on any other platform. But it is always worth giving this a try if you are starting to use Vertica and would like to see your tables and write queries on a GUI based environment. I am not a big fan of GUIs. But some times it might become handy. Especially if you are a DBA and you manage quite a lot of databases. Okay so once you have installed DbVisualizer, open it. So first thing you should do is to configure a driver that you can use to connect to Vertica databases. DbVisualizer comes with a lot of common drivers, but then HP's Vertica isn't a very common database technology. I...

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. And even though we would get our own dedicated cluster for production, at the moment for development we have been sharing a cluster. And this has proved to be painful and slow. Database designer helps generate projections that can improve query performance and also improve load performance, depending on what you choose when running it. But this bloody tool can only be run by a super user which happens to be our systems engineering team. They aren't ready to do any sort of other work for us, but they want to have control of DBD. Totally insane logi...

Powered by Blogger

History of Programming Languages an Infographic

Comments

Post a Comment