Vertica[l] Bits

HP Vertica Analytic Database: Technical problems and their solutions. This is a personal blog and is not related to and/or supported by Vertica Systems Inc.

Sunday, 17 February 2013

Some Useful System Queries

›

1. To see all the queries currently running: vsql=> select user_name, session_id, transaction_id, statement_id, request, request_durati...

Saturday, 9 February 2013

Tuple Mover Mergeout, Replay Delete & Locks

›

Tuple Mover operation Mergeout is the process of consolidating ROS containers and purging deleted records. These ROS containers (called ROSs...

Monday, 28 January 2013

Want to store frequently accessed data on a faster storage (SSD)? Storage Policies can help.

›

Vertica "Storage Locations", as Vertica users know are storage paths on disk that you specify to store data and temp files. Each ...

Tuesday, 25 December 2012

COPY: How to skip first column that has a different delimiter

›

I had this very interesting problem sometime back wherein customer had a data file with first column delimiter different from rest of the co...

Sunday, 23 December 2012

Changing row delimiter in VSQL

›

Consider a scenario when you export some data with VSQL and some of the string columns have new line characters as part of column value. No...

Home

View web version

About Me

Unknown

View my complete profile

Powered by Blogger.