Installing a Single-Node HPE Vertica for a testing purpose:
1) Install Virtual Box.
2) Install Ubuntu with your Virtual Box: http://www.simplehelp.net/2015/06/09/how-to-install-ubuntu-on-your-mac/
- Make sure what version is supported: https://my.vertica.com/docs/7.2.x/PDF/HP_Vertica_7.2.x_Supported_Platforms.pdf
- How to ssh VM from Mc: https://www.quora.com/How-can-I-ssh-into-my-VM-from-the-Mac-OS-X-host
3) Installing a Single-Node HPE Vertica 8 Cluster on Ubuntu 14.04: http://www.dbjungle.com/installing-a-single-node-hpe-vertica-8-cluster-on-ubuntu-14-04/
- Verify if you are using bash
- Command to install additional changes (run as a root): /opt/vertica/sbin/install_vertica --hosts 127.0.0.1 --deb /<your path>/vertica_8.0.0-3_amd64.deb --data-dir /db/vertica/
- My installation failed few times, but there is a nice explanation of the error. I hit these problems:
https://my.vertica.com/docs/8.0.x/HTML/index.htm#cshid=S0020
https://my.vertica.com/docs/8.0.x/HTML/index.htm#cshid=S0305
- Admintools - you will have to run it as dbadmin user: /opt/vertica/bin/admintools
4) Install Vertica using Mac Book: http://www.dbjungle.com/hpe-vertica-on-macbook-pro-all-you-need-to-know/
5) Via Admin tool, you can create database, start the database and run the queries (if you don't know the syntax of the queries, you can always google)
6) In the SDC UI, you can use as a:
- JDBC Driver Class Name: jdbc:vertica://VerticaHost:portNumber/databaseName
-
JDBC Driver Class Name: com.vertica.jdbc.Driver
