Thursday, November 21, 2013

How to install HP Vertica

[root@vertica6 ~]# yum install ./vertica-6.1.2-0.x86_64.RHEL5.rpm
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: mirrors.hostemo.com
* extras: mirror.usonyx.net
* updates: mirror.usonyx.net
base                                                                                                                                                                                                                                                   | 3.7 kB     00:00    
base/primary_db                                                                                                                                                                                                                                        | 4.4 MB     00:05    
extras                                                                                                                                                                                                                                                 | 3.4 kB     00:00    
extras/primary_db                                                                                                                                                                                                                                      |  18 kB     00:00    
updates                                                                                                                                                                                                                                                | 3.4 kB     00:00    
updates/primary_db                                                                                                                                                                                                                                     | 3.3 MB     00:01    
Setting up Install Process
Examining ./vertica-6.1.2-0.x86_64.RHEL5.rpm: vertica-6.1.2-0.x86_64
Marking ./vertica-6.1.2-0.x86_64.RHEL5.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package vertica.x86_64 0:6.1.2-0 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================
Package            Arch       Version      Repository                       Size
==================================================================================
Installing:
vertica            x86_64     6.1.2-0      /vertica-6.1.2-0.x86_64.RHEL5   364 M

Transaction Summary
==================================================================================
Install       1 Package(s)

Total size: 364 M
Installed size: 364 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : vertica-6.1.2-0.x86_64                                                                                                                                                                                                                                     1/1

Vertica Analytic Database V6.1.2-0 successfully installed on host vertica6.dbaglobe.com

----------------------------------------------------------------------------------
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


  Verifying  : vertica-6.1.2-0.x86_64                                                                                                                                                                                                                                     1/1

Installed:
  vertica.x86_64 0:6.1.2-0                                                                                                                                                                                                                                                   

Complete!


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

Vertica Analytic Database 6.1.2-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 127.0.0.1
Default shell on nodes:
127.0.0.1 /bin/bash
Info: the package 'pstack' is useful during troubleshooting.  Vertica recommends this package is installed.
Checking/fixing OS parameters.....

Setting vm.min_free_kbytes to 67584 ...
Info! The maximum number of open file descriptors is less than 65536
Setting open filehandle limit to 65536 ...
Info! The session setting of pam_limits.so is not set in /etc/pam.d/su
Setting session of pam_limits.so in /etc/pam.d/su ...
Info! Parameter vm.max_map_count is less than 253068
Setting vm.max_map_count to 253068 ...
Detected cpufreq module loaded on 127.0.0.1
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:
Setting /etc/security/limits.conf nproc  to 3954 ...
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 127.0.0.1
... Done
Error Monitor  0 errors  3 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.

[dbadmin@vertica6 ~]$ ls -l /opt/vertica/config/licensing/vertica_community_edition.license.key
-rw-rw-rw-. 1 root root 586 May 28 10:45 /opt/vertica/config/licensing/vertica_community_edition.license.key


[root@vertica6 ~]# su - dbadmin
[dbadmin@vertica6 ~]$
[dbadmin@vertica6 ~]$
[dbadmin@vertica6 ~]$ /opt/vertica/bin/adminTools

[dbadmin@vertica6 VMart_Schema]$ vsql -d vmart -U dbadmin -w p_ssw0rd -f vmart_define_schema.sql
[dbadmin@vertica6 VMart_Schema]$ vsql -d vmart -U dbadmin -w p_ssw0rd -f vmart_load_data.sql
Rows Loaded
-------------
        1826
(1 row)

Rows Loaded
-------------
         500
(1 row)

Rows Loaded
-------------
          50
(1 row)

Rows Loaded
-------------
         100
(1 row)

Rows Loaded
-------------
          50
(1 row)

Rows Loaded
-------------
       50000
(1 row)

Rows Loaded
-------------
       10000
(1 row)

Rows Loaded
-------------
         100
(1 row)

Rows Loaded
-------------
         100
(1 row)

Rows Loaded
-------------
        1000
(1 row)

Rows Loaded
-------------
         200
(1 row)

Rows Loaded
-------------
     5000000
(1 row)

Rows Loaded
-------------
      300000
(1 row)

Rows Loaded
-------------
     5000000
(1 row)

Rows Loaded
-------------
      300000
(1 row)