My Experiences with Databases & More

Oracle-MySQL-SQL SERVER-Python-Azure-AWS-Oracle Cloud-GCP etc

  • Enter your email address to follow this blog and receive notifications of new posts by email.

  • Total Views

    • 558,488 hits
  • $riram $anka

    The experiences, Test cases, views, and opinions etc expressed in this website are my own and does not reflect the views or opinions of my employer. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.Product and company names mentioned in this website may be the trademarks of their respective owners.

Archive for the ‘Vertica’ Category

HP Vertica – an analytic database management software – Installation

Posted by Sriram Sanka on November 5, 2013


The grid-based, column-oriented, Vertica Analytics Platform is designed to manage large, fast-growing volumes of data and provide very fast query performance when used for data warehouses and other query-intensive applications. The product claims to drastically improve query performance over traditional relational database systems, provide high-availability, and petabyte scalability on commodity enterprise servers.

Its design features include:

  • Column-oriented storage organization, which increases performance of sequential record access at the expense of common transactional operations such as single record retrieval, updates, and deletes.[6]
  • Standard SQL interface with many analytics capabilities built-in, such as time series gap filing/interpolation, event-based windowing and sessionization, pattern matching, event series joins, statistical computation (e.g., regression analysis), and geospatial analysis.
  • Out-of-place updates and hybrid storage organization, which increase the performance of queries, insertions, and loads, but at the expense of updates and deletes.
  • Compression, which reduces storage costs and I/O bandwidth. High compression is possible because columns of homogeneous datatype are stored together and because updates to the main store are batched.[7]
  • Shared nothing architecture, which reduces system contention for shared resources and allows gradual degradation of performance in the face of hardware failure.
  • Easy to use and maintain through automated data replication, server recovery, query optimization, and storage optimization.
  • Support for standard programming interfaces ODBCJDBC, and ADO.NET.

Key Features of the Vertica Analytics Platform

Today ..I am going to install  HP vertica  On one of my test server……

A proper & complete Installation guide can be found @

Lets Download and install vertica from  on  RHEL5 64 Bit

[root@sriram ~]# rpm – iv /media/20131105_1301/vertica-6.1.3-0.x86_64.RHEL5.rpm
Preparing packages for installation…

Vertica Analytic Database V6.1.3-0 successfully installed on host sriram.localdomain

Important Information
If you are upgrading from a previous version, you must backup your database before
continuing with this install. After restarting your database, you will be unable
to revert to a previous version of the software.

To download the latest Vertica documentation in zip or tar format please visit the
myvertica web site.

To complete installation and configuration of the cluster,
run: /opt/vertica/sbin/install_vertica

[root@sriram ~]# /opt/vertica/sbin/install_vertica

Vertica Analytic Database 6.1.3-0 Installation Tool
Upgrading admintools meta data format..
scanning /opt/vertica/config/users
WARNING: No hostname list provided. Installing to localhost
Starting installation tasks…
Getting system information for cluster (this may take a while)….
backing up admintools.conf on
Default shell on nodes: /bin/bash
Checking/fixing OS parameters…..

Setting vm.min_free_kbytes to 51200 …
Info! The maximum number of open file descriptors is less than 65536
Setting open filehandle limit to 65536 …
Info! The session setting of is not set in /etc/pam.d/su
Setting session of in /etc/pam.d/su …
Info! Parameter vm.max_map_count is less than 253086
Setting vm.max_map_count to 253086 …
Detected cpufreq module loaded on
CPU frequency scaling is enabled. This may adversely affect the performance of your database.
Vertica recommends that cpu frequency scaling be turned off or set to ‘performance’

Creating/Checking Vertica DBA group

Creating/Checking Vertica DBA user

Password for dbadmin:
Installing/Repairing SSH keys for dbadmin

Creating Vertica Data Directory…

Updating spread configuration…
Verifying spread configuration on whole cluster.
Creating node node0001 definition for host
… Done
Error Monitor 0 errors 2 warnings
Installation completed with warnings.
Installation complete.

To create a database:
1. Logout and login as dbadmin.**
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu

** The installation modified the group privileges for dbadmin.
If you used sudo to install vertica as dbadmin, you will
need to logout and login again before the privileges are applied.

[root@sriram ~]#

To create a database:
1. Logout and login as dbadmin.**
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu

Now login as dbadmin and accept the license agreement ! Once after that now a window  will appear, using which  you can create & configure Vertica DB.


After Database creation you can see the below Interactive window for Regular operations !



You can See the documentation Guide @

Thanks for reading this ! 

Sriram Sanka|Sr.Oracle DBA


Posted in Vertica | 10 Comments »

Tales From A Lazy Fat DBA

Its all about Databases & their performance, troubleshooting & much more .... ¯\_(ツ)_/¯

Thinking Out Loud

Michael T. Dinh, Oracle DBA

Notes On Oracle

by Mehmet Eser

Oracle Diagnostician

Performance troubleshooting as exact science


get sum oracle stuffs

Data Warehousing with Oracle

Dani Schnider's Blog


Oracle DBA's Daily Work

Welcome everyone!! The idea of this blog is to help the DBA in their daily tasks. Enjoy.

Anand's Data Stories

Learn. Share. Repeat.

Tanel Poder's blog: Core IT for geeks and pros

Oracle Performance Tuning, Troubleshooting, Internals

Yet Another OCM

Journey as an Oracle Certified Master

Sharing Knowledge is ultimate key to Gaining knowledge...

Neil Chandler's DB Blog

A resource for Database Professionals

DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBA's become bulletproof!

OraExpert Academy

Consulting and Training

%d bloggers like this: