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