My Experiences with Databases

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

    • 500,316 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.

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


10 Responses to “HP Vertica – an analytic database management software – Installation”

  1. I blog frequently and I genuinely thank you for your content.
    Your article has truly peaked my interest. I will take a note of your blog
    and keep checking for new information about once a
    week. I subscribed to your RSS feed too.


  2. This will Pass

    My brother recommended I may like this web site. He was once totally right. This post actually made my day. You cann’t believe simply how much time I had spent for this information! Thank you!


  3. I’ve got be shown a very few good items here. Definitely worthy of social bookmarking with regard to revisiting. I wonder exactly how a great deal of effort you set to generate such a good helpful site.


  4. HP Vertica – an analytic database management software – Installation «


  5. HP Vertica – an analytic database management software – Installation «


  6. torrent said

    I haven’t checked in here for a while because I thought it was getting boring, but the last few posts are good quality so I guess I will add you back to my daily bloglist. You deserve it friend 🙂


  7. Hey! I’m at work surfing around your blog from my
    new iphone 4! Just wanted to say I love reading your blog and
    look forward to all your posts! Keep up the excellent work!


  8. Wow, that’s what I was looking for, what a material! present here at this
    web site, thanks admin of this site.


  9. Excellent read, I just passed this onto a colleague who was doing some research on that. And he just bought me lunch since I found it for him smile So let me rephrase that: Thank you for lunch!


  10. data loss said

    Your means of explaining all in this article is really pleasant, every one be capable of effortlessly understand it,
    Thanks a lot.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: