Categories:

What is Vertica?

Industry Specialties: Serves all industries

Vertica is an analytics and data exploration platform designed to ingest massive quantities of data, parse it, and then return business insights as reports and interactive graphics. Elastically scalable, it provides batch as well as streaming analytics with massively parallel processing, ANSI-compliant SQL querying and ACID transactions.

Deployable in the cloud, on-premise, on Apache Hadoop and as a hybrid model, its resource manager enables concurrent job runs with reduced CPU and memory usage and data compression for storage optimization. A serverless setup and advanced data trawling techniques help users store and access their data with ease.
PRICE
$
$
$
$
$
COMPANY SIZE
S
M
L
DEPLOYMENT
PLATFORM
Try Before You Buy.
Request a Free Demo Today!
Request Demo
It's completely free!
ScreenshotsScreenshotsScreenshots
Product Screenshots and Videos

#31

Vertica is ranked #31 in the Big Data Analytics Tools product directory based on the latest available data collected by SelectHub. Compare the leaders with our In-Depth Report.

Get the Report Now

Vertica Pricing

Based on our most recent analysis, Vertica pricing starts at $3 (Per Hour, Usage-Based).

Get Price Quote
Price
$
$
$
$
$
i
Starting From
$3.19
Pricing Model
Per Hour, Usage-Based
Free Trial
Yes, Request for Free

Training Resources

Vertica is supported with the following types of training:

Documentation
In Person
Live Online
Videos
Webinars

Support

The following support services are available for Vertica:

Email
Phone
Chat
FAQ
Forum
Help Desk
Knowledge Base
Tickets
Training
24/7 Live Support

Vertica Benefits and Insights

Why use Vertica?

Key differentiators & advantages of Vertica

  • Improve Decision Making: Get business insights like workforce metrics, retail information, vital proprietary intel and usage data through data ingestion from diverse sources. Its high-level overview of diverse data pools empowers data-driven business decisions. 
  • Self-Service Analytics:  Provide self-service reporting and analysis for users of all skill levels — from non-technical users to analysts — at a more sophisticated level, using custom formulas and algorithms. 
  • Big Data Insights: Get intel and insights through large data silos to enrich business decisions and diagnose pain points or attach victories to actionable data. 
  • Gain a Competitive Advantage: Take on competitors and optimize business operations through data-informed decision-making. 
  • Flexible Licensing: Buy the product outright, purchase a subscription or pay by the hour with its flexible licensing. Hourly usage comes with full support and requires no commitment. 

Industry Expertise

The system provides analytics to multiple clients in diverse industries across the world. These include retail, banking, internet, information technology, government, health, education, computer hardware and software, marketing and advertising.

Vertica Reviews

Average customer reviews & user sentiment summary for Vertica:

User satisfaction level icon: great

203 reviews

88%

of users would recommend this product

Vertica has a 'great' User Satisfaction Rating of 88% when considering 203 user reviews from 3 recognized software review sites.

Synopsis of User Ratings and Reviews

Based on an aggregate of Vertica reviews taken from the sources above, the following pros & cons have been curated by a SelectHub Market Analyst.

Pros

  • Data Processing: All users who mention computing say that the tool’s columnar storage and parallel processing enable faster querying.
  • Performance: Almost 72% of the users who review performance say the platform is robust and reliable with high availability.
  • Functionality: Around 56% of the users who review functionality say that it is feature-rich and performs as expected.

Cons

  • Cost: All users who mention cost say that data storage limits can be restrictive and the tool is expensive.
  • Community Support: Citing lack of technical community support, approximately 50% of the users say that it makes adoption difficult.

Researcher's Summary:

Vertica Analytics is a big data relational database that provides batch as well as streaming analytics to enterprises. Citing a robust, distributed architecture with massively parallel processing (MPP), all users who review data processing say that it performs extremely fast computing with I/O optimization, and columnar storage makes it ideal for reporting. Approximately 72% of the users who review performance say that it is a reliable tool with high availability and virtually no downtime, with K-safety protocol in place for efficient fault tolerance. Citing its feature set, around 56% of the users say that they are satisfied with its elastic scalability, rich analytical functions and excellent clustering technology.
On the flip side, almost 50% of the users who mention technical and community support say that it is inadequate and possibly contributes to the platform’s steep learning curve. All users who review its cost say that the solution is expensive, with restrictive data storage limits.
In summary, Vertica is a big data and analytics platform that provides streaming analytics with lightning-fast query speeds, machine learning and forecast capabilities.

Key Features

  • Streaming Analytics: Connects to Apache Kafka for IoT data analysis in real time. Analyzes and manages large volumes of data from IoT devices such as machine and sensor data for buildings, vehicles, medical systems, smart devices and wearables. 
  • Machine Learning: Get automated insights and deliverables through machine learning modules that automatically digest and parse large data portions. ML modules are built into its core — no need to pay for them or install them separately. 
  • Software Only: Work with a robust software interface with dedicated IT resources. All data warehousing, storage and processing infrastructure is hosted offsite. 
  • Fast SQL Databases: Store and retrieve data through highly scalable and speedy SQL databases. 
  • Massively Parallel Processing: Get increased speed and scalability at larger scales by running two processes side-by-side through massively parallel processing. 
  • Columnar Storage: Read only the most important sets of data first through columnar storage that greatly speeds up data retrieval. 

Limitations

Some of the product limitations include:

  •  Doesn’t support enforcing foreign keys and referential integrity. 
  •  Doesn’t support automatic constraints on external tables. 
  •  Deletion is time-consuming and can delay other processes in the pipeline. 

Suite Support

Before emailing support, go through the self-help resources on the vendor’s online support portal, which include a knowledge base, documentation, guides, FAQs and support forums.

Premium plan subscribers receive access to enterprise-level support with a dedicated technical account manager. Subscribe to business support for access to 24/7 support on call, competitive response times and product updates.

mail_outlineEmail: Not available. Fill the Contact Us form on the vendor’s website or chat with a customer representative through their online support portal.
phonePhone: +1-800-632-6265.
schoolTraining: Get certified at the online Vertica Academy with self-paced, instructor-led and on-demand training, and custom workshops. The company also has a certification program, though the cost may vary per certification.
local_offerTickets: Submit a ticket through a Micro Focus account on the vendor’s website.
Compare products
Comparison Report
Just drag this link to the bookmark bar.
?
    Table settings

    Compare Big Data Analytics Tools

    These are the products most often compared to Vertica.

    You can choose 5 products to compare
    SAS Viya product logo
    SAS Viya
    IBM Watson Studio product logo
    IBM Watson Studio
    Spotfire product logo
    Spotfire
    Dataiku product logo
    Dataiku
    H2O.ai product logo
    H2O.ai
    SAP Analytics Cloud product logo
    SAP Analytics Cloud
    Oracle Analytics Cloud product logo
    Oracle Analytics Cloud
    RapidMiner product logo
    RapidMiner
    KNIME product logo
    KNIME
    Alteryx product logo
    Alteryx

    Head-to-Head
    Comparison

    Vertica Software Tool

    vs

    Similar Products

    Here are the most similar products to Vertica.

    Analyse-it product logo
    Analyse-it
    Dundas BI product logo
    Dundas BI
    Azure Big Data product logo
    Azure Big Data
    Microsoft Machine Learning Server product logo
    Microsoft Machine Learning Server
    Zoomdata product logo
    Zoomdata
    GridGain product logo
    GridGain
    Apache Phoenix product logo
    Apache Phoenix
    Striim product logo
    Striim
    Arcadia Data product logo
    Arcadia Data
    Actian product logo
    Actian
    Your review has been submitted
    and should be visible within 24 hours.
    Your review

    Rate the product

    Company Details

    mandatory fields

    Industry
    Choose your main industry
    Company Size
    Choose your company size