Installing 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 installed! unixODBC 2.2.x is NOT supported by┬áMS SQL Server Linux client. If you try to install any VERSIONs SQL-Server client for Linux 6.x without installing unixODBC 2.3.0 (Not 2.3.+) it’ll will end up… Read More Installing MS SQL Server Client on Linux (Vertica nodes)

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 SSH Key. In this post, I’ll use Vertica Development server as source and Vertica production server as target In other words I’ll set up password less login for my ID from Development server to Production server.… Read More Creating SSH Key for programmatic login to Linux servers

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 avoid frustrations. Here I’ll document them as I find, so that others may benefit. String to Date format conversion: This is fairly well documented here: http://drill.apache.org/docs/data-type-conversion/ For people, coming from Oracle world the… Read More Drill SQL Date / Time manipulations and other Tidbits…

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 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://CENTOS:5450/webui Accept the License In configuration screen specify Username: dbadmin Pw: <current pw>… Read More Install Vertica MC 7.1.1.0