Vertica is an analytical database that is grid-based and column-oriented that was designed to manage large, fast growing volumes of data that provides very fast query performance when used for data warehouses and other query-intensive applications. In this post, I will show how to get going with Vertica’s community edition VM appliance that’s available to all. So, if you are interested to get hands on with Veritca, then read-on and try it for yourself.
Vertica is available as a Virtual Machine (VM) that is pre-installed on a 64-bit Cent OS image and comes with a license for 500 GB of data storage. You can download the VM from http://my.vertica.com after you register.
Here is the page and link I downloaded it from:
Here is what you’ll see once you download and unzip the image:
Installing the VM
I used Oracle’s VirtualBox to import the image.
After you import the image, you’ll first want to Enable IO APIC under System properties otherwise you are likely to get an error.
One of the issues I ran into is related to X Windows. This is something that automatically corrected for me with the onscreen self diagnosis the system provided. I don’t think I changed any other setting for this.
Once, the above error was fixed, I was then able to login.
To log into the virtual machine:
The first time you boot the virtual machine you are automatically logged in and a web page
displays further instructions. To log back into the virtual machine, use the following username
• Username: dbadmin
• Password: password
• Root Password: password
Install the Sample Database
Next it is time to install the sample database.
Launch terminal cd /opt/vertica/sbin
I did not run into any issues installing the database.
Connecting to the database
Launch ./vsql from /opt/vertica/bin
run a simple query: select count(1) from store.store_sales_fact;
There there you go, we installed the VM appliance, the database and tested connecting with the DB. I’m really hoping to get a lot more hands on in the near future. Subscribe to my blog if you’d like to receive email notifications about future posts.