Starting Vertica 7.1 database

When Vertica database is not running on the cluster and a user tries to connect to the database using vsql following message is issued. sudhakar@sudhakar-Latitude-E6420:~$ sudo su – dbadmin [sudo] password for sudhakar: dbadmin@sudhakar-Latitude-E6420:~$ vsql vsql: could not connect to server: Connection refused Is the server running on host “???” and accepting TCP/IP connections on… Read More Starting Vertica 7.1 database

Installing MC (Management Console) for HP Vertica

High level steps: Download vertica-console-7.1.1-0.x86_64.RHEL5.rpm from Vertica portal rpm -Uvh vertica-console-7.1.1-0.x86_64.RHEL5.rpm *** Please do NOT close this terminal or SSH session *** When message “StartedSslSelectChannelConnector:<ipaddress>:5450 STARTING” shows up… In a browser go to https://<HOSTNAME or IP Address>:5450/webui Accept the License In configuration screen specify Username: dbadmin Pw: <current pw> Unix group ID = verticadba Default… Read More Installing MC (Management Console) for HP Vertica

Step-By-Step for Running DBD from CLI in Vertica 7.1

The steps and examples have been borrowed from Vertica Documentation! I am just walking through learning and sharing my experience… No Rights claimed here. In this DEMO I’ll create two tables (which can be joined and queried) with FK relationship and feed a sample query to DBD to suggest and deploy the required projections. Let… Read More Step-By-Step for Running DBD from CLI in Vertica 7.1

Installing Vertica on AWS m3.medium RHEL instance…

Initiate the instance on AWS using RHEL AMI with instance type c3.medium. We’ll be installing Vertica on single node. Please note For RHEL instance the login user is ec2-user (and not root). However ec2-user is already in sudoers list and has all the required privileges for Vertica install. In this post we’ll walk through step… Read More Installing Vertica on AWS m3.medium RHEL instance…

Adding SWAP space to AWS c3.medium instance

To add swap space use the following steps: sudo to root [ec2-user@ip-10-167-158-108 ~]$ sudo -s [root@ip-10-167-158-108 ec2-user]# Check the swap space #CHECK SWAP space… [ec2-user@ip-10-167-158-108 ~]$ grep SwapTotal /proc/meminfo SwapTotal: 0 kB [ec2-user@ip-10-167-158-108 ~]$ Add swap space Type the following command to create 512MB swap file (1024 * 512MB = 524288 block size): [root@ip-10-167-158-108 ec2-user]#… Read More Adding SWAP space to AWS c3.medium instance

Vertica 7.0 Analytics Database Instance on AWS (Single Node)

In this post we’ll go through the steps to create a running instance of Vertica 7.0 Analytics Database on AWS using HP Vertica AMI. This post assumes you are familiar with AWS and have an active account. In AWS console from EC2 instance page Launch instance. Choose AMI Market Place -> Search for Vertica. One… Read More Vertica 7.0 Analytics Database Instance on AWS (Single Node)