G2 Crowd User

User Friendly

over 1 year ago

Is it hard to learn to be a Vertica user? Admin?

Vendor Responses

Response by Vertica

over 1 year ago

From the user perspective, Vertica is a database. It acts exactly like other databases in that it supports standard ANSI SQL and it works with common ETL and visualization tools. Users will only know the difference when their queries run faster.

From an administrative perspective, there are also many similarities to other common databases in the field. However, there are some differences in optimization of queries. Commonly in other solutions, you’re dealing with indexes and materials views for optimization. Vertica uses a feature called projections. To understand projections and other administrative tasks, it’s good to have a solid understanding of columnar databases and how Vertica works. Differences in columnar and tools like our management console and query optimizer may require some study. We have some great documentation online (https://my.vertica.com/docs/8.0.x/HTML/index.htm), free online training (https://my.vertica.com/resources/web-based-training/), feature videos (https://www.youtube.com/channel/UC7Ca4IZjxee3NFC78-PMMEg) and in-person training programs that can simplify learning.