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

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 installed! unixODBC 2.2.x is NOT supported!!! 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… Read More Install MS SQL Server Client on Linux (Vertica nodes)