Your journey to database proficiency
HPE Vertica 8 was released back in August. This post will cover basic installation of single-node Vertica 8.0.0 cluster on Ubuntu Server. My assumptions this is minimal install, which is not intended for production use I am not worried about redundancy, so I can do a single-node cluster I am not planning to do benchmarking Read More …
A lot of people who are new to Vertica ask if you can create an index on a table in a Vertica database. The answer they get is NO. Vertica does not have a CREATE INDEX statement and does not have the concept of an index. Let’s see if we can come up with something Read More …
The performance level of your queries in Vertica depend on the design of your projections. In the projection definitions you specify how your data will be segmented and how your data will be sorted. If you are going to make the right choices your queries will perform really well. I covered projection segmentation in my Read More …
