Build EC2 RHEL Client Box for Development
In this post I’ll describe creating an EC2 RHEL 8.0 client instance that will be used for accessing and administering various DB...
Are you ready for Big Data Analytics @ Scale?
The Systems People Inc.
sudhakar
- Aug 10, 2019
- 6 min
Installing Python 3.6+ on Nodes on CentOS 6.5 (also install PIKA)
We recently upgrade our Vertica cluster to 9.x, however our OS is still CentOS 6.5. OS upgrade to 7.x will be scheduled in near future....
5 views0 comments
sudhakar
- Jul 10, 2019
- 8 min
Installing MS SQL Server Client on Linux (Vertica nodes)
Photo by luis gomes on Pexels.com We are running Centos 6.5 (Redhat version) of Linux on our DEV, STG, PROC clusters. Centos 6.5 comes...
7 views0 comments
sudhakar
- Jul 10, 2019
- 1 min
Creating SSH Key for programmatic login to Linux servers
SSH login requires password to be specified. In order to programmatic login to target server with needing to specify password, we can use...
5 views0 comments
sudhakar
- Jun 26, 2019
- 2 min
Drill SQL Date / Time manipulations and other Tidbits…
Apache Drill (with MapR distribution) implements most ANSI SQL functions, however there are some nuances that you need to be aware of, to...
4 views0 comments
sudhakar
- Jun 26, 2019
- 1 min
Install Vertica MC 7.1.1.0
The following steps worked for me in my test server. High level steps: Download vertica-console-7.1.1-0.x86_64.RHEL5.rpm from Vertica...
1 view0 comments
sudhakar
- Jun 13, 2019
- 7 min
Install MS SQL Server Client on Linux (Vertica nodes)
We are running Centos 6.5 (Redhat version) of Linux on our DEV, STG, PROC clusters. Centos 6.5 comes with default unixODBC 2.2.x...
2 views0 comments
sudhakar
- Dec 6, 2017
- 5 min
Backup Restore on Vertica DB (Part 2)
In Part 1 of the write-up, we had walked through steps for configuring and taking a full backup of Vertica database. In this section,...
4 views0 comments
sudhakar
- Dec 6, 2017
- 3 min
Backup Restore on Vertica DB (Part 1)
Walkthrough Backup-Restore on Vertica DB cluster (Single Node) On version 8.0.0-0 version of Vertica DB, we walk through in this section...
3 views0 comments
sudhakar
- Nov 8, 2017
- 7 min
Vertica Upgrade from version 8.0.x to 9.0.x on CentOS 6.5 – 3N Cluster
With release of version 9.0.x release in October 2017, Vertica is dropping support of 7.x and 8.x. Upgrading to 9.0 is highly recommended...
4 views0 comments
sudhakar
- Nov 8, 2017
- 3 min
Vertica Upgrade from version 8.1.x to 9.0.x on CentOS 6.5
With release of version 9.0.x release in October 2017, Vertica is dropping support of 7.x and 8.x. Upgrading to 9.0 is highly recommended...
5 views0 comments
sudhakar
- Nov 29, 2014
- 1 min
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....
1 view0 comments
sudhakar
- Nov 24, 2014
- 1 min
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...
4 views0 comments
sudhakar
- Nov 23, 2014
- 7 min
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...
4 views0 comments
sudhakar
- Nov 23, 2014
- 2 min
Creating Database in HP Vertica 7.1
In previous post I downloaded and installed HP Vertica 7.1 database software in Ubuntu 14.4. In this follow-up I’ll create a test...
2 views0 comments