T-Ek-nolo-G-i-K

Search This Blog

Perl module installation - Ubuntu

February 05, 2014

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Ever wondered how to install a Perl module from CPAN:

sudo perl -MCPAN -e 'install ModuleName'

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

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. We can make modifications to these projections manually or run the Database Designer to generate projections for us. Sometimes to get the best performance we have to write query specific projections. How do we write Query Specific projections? First thing is to check out the query plan of our problematic query. Use EXPLAIN PLAN to check this out. What you spot there is what you have to work on. That sounds simple. But how do I deal with what I spot in explain plan? More about Explain PLAN Output in Vertica can be found at https://my.vertica

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

Exploring Vertica's INTERPOLATE predicate

Vertica 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 couldn't understand what was happening. So I posted a question at Stackoverflow

Powered by Blogger

Perl module installation - Ubuntu

Comments

Post a Comment