You can "pivot" rows into columns via the DECODE function. Here is a quick example using runs scored per season by a few MLB teams ( Note : The scores are made up because I was too lazy to Google actuals). First I'll create a table name MLB and insert some data: dbadmin=> create table mlb (season IN...

Hi, There is a similar feature in Vertica implemented as Historical (Snapshot) Queries. There are two options: Query all committed data in the database up to, but not including, the current epoch Query all committed data in the database up to the time stamp specified. AT TIME 'timestamp' queries are...

Hi, We can create really basic user-defined SQL functions and more complex externally defined functions (written in c++). The user-defined SQL functions are best used when migrating SQL statements from other databases where those SQL statement reference functions that do not exist in Vertica. For in...

HI, Graphviz is open source graph visualization software. Graph visualization is a way of representing structural information as diagrams of abstract graphs and networks. You can download the GVEdit software from http://www.graphviz.org/ . For instance, I installed the Windows version and cut and pa...

Hi jsbaskin, Projection data in Verica is stored in ROS (Read Optimized Storage) containers on disk. The root location on disk where your data is located can be found by querying the DISK_STORAGE system table: dbadmin=> select storage_path from v_monitor.disk_storage where storage_usage = 'DATA'; st...

Hello, There are actually three separate prompts in vsql that can be customized. These prompts are linked to variables appropriately name PROMPT1 , PROMPT2 , and PROMPT3 . The variables store strings and special characters that are used to determine how the prompts are displayed on screen. PROMPT1 i...

Wow! Sad news out from Vertica (as reported in an email this morning) that Christopher Lynch (President and CEO) has left Vertica... Dear Friends, After two incredible years I am leaving HP-Vertica effective immediately. I want to thank HP and all of our customers, partners, investors, and employees...